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

Paul has attended:
Excel Intermediate course

Times

how do you clculate time after 24 hours?

RE: times

Hi Paul,

Hope you enjoyed the Excel Intermediate training.

Thanks for the question, and welcome to the forum.

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?

We look forward to answering any future questions you may have about your course.

Regards, Rich


 

Excel tip:

Finding cells that have data restrictions

Click anywhere on the worksheet.
On the Edit menu, click Go To.
Click Special.
Click Data validation.
Click All.

View all Excel hints and tips


Server loaded in 0.07 secs.