times

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Times

Times

resolvedResolved · Low Priority · Version 2003

Julie has attended:
Excel Intermediate course

Times

how do you calculate times after 24hrs

RE: times

Make the answer cell (eg. C1) to be date/time 1 - date/time 2
eg. =B1-A1

Select C1
Go to Format -> Cells
Select Number tab and choose "custom" in category.
Enter the text "[h]:mm:ss;@" in type text box.
It should show you how many hours have passed.

I hope this answers your question?

Regards, Rich


 

Excel tip:

Bring up formatting dialog box

Ctrl+1

View all Excel hints and tips


Server loaded in 0.09 secs.