Making a simple timesheet in Numbers...

Discussion in 'Mac Apps and Mac App Store' started by Mavimao, Oct 4, 2009.

  1. Mavimao macrumors 6502a

    Mavimao

    Joined:
    Feb 16, 2005
    Location:
    Lyon, France
    #1
    So I'm working this job where I need to keep track of my hours. I have rows of 4 columns. A is just the date and other random task info. B is the starting time, C is the ending time and D should be how many hours I worked on that particular day. The only problem is, I can't for the life of me figure out how to get Numbers to add up my hours automatically!! The SUM function just gives me the red triangle of WTF.

    It's probably something really simple but this is my first attempt at spreadsheeting so easy on me all the Nick Burns out there ;)
     
  2. Xapphire13 macrumors regular

    Xapphire13

    Joined:
    Jan 14, 2009
    Location:
    South Australia
    #2
    Write your times in 24 hour format and an extra column for minutes
    so have:
    B as starting hr
    C as starting min
    D as end hr
    E as end min
    F as work time with the formula =(D1+(E1/60))-(B1+(C1/60))


    OR set the format as time
    then have work time as end time minus start time
    for total work time have a box doing the SUM of all work time boxes
    works in excel at least

    If you want an example I can make one and post
     
  3. Mavimao thread starter macrumors 6502a

    Mavimao

    Joined:
    Feb 16, 2005
    Location:
    Lyon, France
  4. Xapphire13 macrumors regular

    Xapphire13

    Joined:
    Jan 14, 2009
    Location:
    South Australia

Share This Page