Excel help needed

Discussion in 'Mac Apps and Mac App Store' started by decafjava, Oct 8, 2017.

  1. decafjava macrumors 68030

    decafjava

    Joined:
    Feb 7, 2011
    Location:
    Geneva
    #1
    Hello I need help with an Excel spreadsheet. I have one that is set as a table with days of the month and starting times (of a workday) in one column, the ending time (in the 24 hour format) in the second and the total hours and minutes worked in the third. I would like to add up the total hours in minutes worked so far as a running total that adds up the time correctly but have not found the way despite my exploration. Can anyone help?
     
  2. decafjava thread starter macrumors 68030

    decafjava

    Joined:
    Feb 7, 2011
    Location:
    Geneva
    #2
    I feel I am missing something pretty basic...
     
  3. GerritV, Oct 9, 2017
    Last edited: Oct 9, 2017

    GerritV macrumors 65816

    Joined:
    May 11, 2012
    #3
    You mean, the results >24 hours going wrong ?
     

    Attached Files:

  4. decafjava thread starter macrumors 68030

    decafjava

    Joined:
    Feb 7, 2011
    Location:
    Geneva
    #4
    No it only gives a sum of 22 hours and there are much more than that...
     
  5. akash.nu macrumors 604

    akash.nu

    Joined:
    May 26, 2016
    #5
    You mean no matter what the other values are, the sum is always 22?!
     
  6. GerritV macrumors 65816

    Joined:
    May 11, 2012
    #6
    I posted a screenshot with numbers, formulas and results.
    Can you do the same perhaps?
     
  7. decafjava thread starter macrumors 68030

    decafjava

    Joined:
    Feb 7, 2011
    Location:
    Geneva
    #7
    Ok I'll try what you suggested and get back to you.
     
  8. jaduff46 macrumors 6502

    jaduff46

    Joined:
    Mar 3, 2010
    Location:
    Second star on the right....
    #8
    Couldn't manipulate the spreadsheet, but it's resetting the total column when it trips over 24 hours as in the 4th entry.

    Convert column C to a decimal number, i.e. 8:40 = 8.66 and it will work as is.
     
  9. GerritV macrumors 65816

    Joined:
    May 11, 2012
    #9
    If my screenshot is the actual problem of the OP, all it takes is to define the format of column D as [hh]:mm instead of hh:mm
     
  10. jaduff46, Oct 9, 2017
    Last edited: Oct 9, 2017

    jaduff46 macrumors 6502

    jaduff46

    Joined:
    Mar 3, 2010
    Location:
    Second star on the right....
    #10
    Actually, just multiply column D * 24 and you'll have a useful numeric total (i.e. sum($c$2:c2)*24).
    Can leave column C formatted as Time.
     

Share This Page

9 October 8, 2017