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
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
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. |