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