Log in

View Full Version : Time calculation formula


Doogen
Jan 6, 2010, 07:45 AM
Im working with a Microsoft works spreadsheet program and trying to put an equation in that will total up my times. All of my times are in Hrs and min and are in separate columns and I want them to total out that way, at the bottom in a total column. What would be the correct formula to use I've been trying for a while and can't fiure it out EX. (Column1) (Column2)
Hours Minutes
4 37
+ 1 29
_________________
Total 6 6 I want the total to look like this if it is even possible
or I'm I going at it the wrong way?

Stratmando
Jan 6, 2010, 08:30 AM
Total the minutes, divide by 60, add that to your hours, whatever is left, is minutes?
Or:
http://www.onlineconversion.com/advanced_time_calculator.htm

JBeaucaire
Jan 6, 2010, 09:53 AM
You wouldn't have this problem if you had stayed with normal time calculation practices. Excel is quite adept at dealing with the vagaries of time math.

You should have 4:37 in one cell and 1:29 in another. Then you can simply add them. =A1+A2