Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel courses - Calculating time
|
|
|
The UK's most regular 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. |
ms excel courses - Calculating time
Resolved · Low Priority · Version Standard
Reply Fri 24 Aug 2007, 11:25Delegate Adam said...
Adam has attended:
Excel Intermediate course
Excel Advanced course
Access Introduction course
Calculating time
I have a rota programme that calculate the amount of hours automatically. But I have to enter for example; 10.75 in the cell A1 and 15.25 in cell B1 for the progrmmae to calculate that the employee worked for 4.5 hours by simply using the formula B1 - A1. This obviously leads to the employees occasionally coming at the wrong time. How do I get it to calculate the amount of hours using proper time?
For upcoming training course dates see: Pricing & availability
RE: Calculating time
1) Time should be formatted as hh:mm
2) Time 10:75 will automatically recalculate to 11:15, which gives you the time difference as 4hr 10mins
3) Cell A1: 11:15 (format in Time)
Cell B1: 15:25 (format in Time)
Cell C1: A1-B1 (format in Time)
Cell D1: =HOUR(C1)+MINUTE(C1)/60 [General format]
OR Cell C1: =HOUR(A1-B1)+MINUTE(A1-B1)/60
[General format]
See if that works
Katie
Reply Fri 31 Aug 2007, 15:52Delegate Adam said...
RE: Calculating time
Hi Katie,
all teh time formats include seconds. The function of this sheet is for a rota to automatically calculate the hours someone has worked.
It would be very laborious to enter or see seconds on the rota, yet their is no time format without seconds as indicated on your answer.
Let me know if you think this can be rectified.
Regards,
Adam
RE: Calculating time
You can customise TIME format.
1) Bring up format cell window;
2) Choose CUSTOM category
3) Type in your preferred format:
hh:mm (h-Hour, m-Minute, s-seconds)
Let me know if you need more help
Katie
|