Help with formulas in numbers

Discussion in 'Mac Apps and Mac App Store' started by gavinbpage, May 28, 2010.

  1. gavinbpage macrumors newbie

    Joined:
    May 28, 2010
    #1
    I'm trying to do a spreadsheet in numbers to keep track of the hours I work and need help with the formula, which I just can't figure out. I need
    Column 1 Date
    Column 2 Time Started e.g 0600
    Column 3 Time End e.g. 1300
    Column for Total Hours e.g.7:00
    I then need another column to put in how many hours i've been paid and how much is still owed.

    Thank you in advance for any help received.
     
  2. mysterytramp macrumors 65816

    mysterytramp

    Joined:
    Jul 17, 2008
    Location:
    Maryland
    #2
    Dates and Times in Numbers can be tricky, and it seems way more complicated than it needs to be, considering how easy it would be to do what you want with Claris/AppleWorks.

    This will work:

    =Time End -Time Started

    But you'll run into trouble if you ever go back and edit a time, because Numbers stores the current date inside a time record. So if today you say your time started at 6 a.m. and ended at 1 p.m., then decide to go back tomorrow to change it to 1:30, you're likely to get 31 1/2 hours.

    Here's what you could do:

    =24*(TIMEVALUE(Time End)-TIMEVALUE(Time Started))

    Sometimes the Cell Format inspector figures out what you want. Lots of time it doesn't. Here, you'd want to format the cell as a Number offering the number decimal places you need. But it's a number (not a date value) and you should be able to easily add whatever columns you need to enter the number of hours you've been paid and to calculate the number of hours you still need payment for.

    mt
     

Share This Page