Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

advanced excel training - time hoursmins

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel training - Time; hours:Mins

advanced excel training - Time; hours:Mins

ResolvedVersion Standard

Alistair has attended:
Excel Advanced course

Time; hours:Mins

Hi,

I'm working in hours and minutes on a spreadsheet. I wish to add up a bunch of times to find the total time. For example 5 days at 8:30 hours (or 8.5) should equal 42:30 (or 42.5), but excel displays the total as 18:30. I have tried the diferent formats for time but can't find anything suitable. Any suggestions?

Cheers
ALi.

RE: Time; hours:Mins

Ooops! Found the answer in you tips section! Cheers.

Also I can't find a search function on your site to search tips and the forum. Do you have one?

Excel tip:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.