98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Times
Times
Resolved · Low Priority · Version 2003
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Finding cells that have data restrictionsClick anywhere on the worksheet. |