Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Time calculation formula (https://www.askmehelpdesk.com/showthread.php?t=432086)

  • Jan 6, 2010, 07:45 AM
    Doogen
    time calculation formula
    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?
  • Jan 6, 2010, 08:30 AM
    Stratmando

    Total the minutes, divide by 60, add that to your hours, whatever is left, is minutes?
    Or:
    http://www.onlineconversion.com/adva...calculator.htm
  • Jan 6, 2010, 09:53 AM
    JBeaucaire

    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

  • All times are GMT -7. The time now is 06:08 AM.