Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses uk - Time Calculation
|
|
|
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. |
excel training courses uk - Time Calculation
Resolved · Low Priority · Version Standard
Reply Thu 15 Nov 2007, 17:07Delegate Michael said...
Michael has attended:
Excel Intermediate course
Excel Advanced course
Time Calculation
How can I enter hours and minutes in cells and then do calculations such as:
- summing cells to get total time in hours and minutes?
- dividing total time by a total quantity of units to get average time in hours and minutes per unit?
For upcoming training course dates see: Pricing & availability
RE: Time Calculation
Hi Michael, Thank you for your post, to answer your question, if you enter the time in the cells in the format hh:mm and then in your cell to obtain the information you woudl use either the formula =cell ref - (minus) cell ref, this will return a number, if you then format the cell to the time fomat hh:mm using a custom format, this will return the difference as a time.
Another method which will return either hours or minutes, use the =INT() function and by changing the extension as required get hour or minute difference for example; =int((cell ref - cell ref)*24) for hours, *1440 for minutes, you can then total or average the answer cells as required, formatting the result as a time should then give you your answers. I hope that helps, regards Pete.
|