1 Reply Latest reply: Oct 23, 2013 2:24 AM by Jerrold Green1
michael721 Level 1 Level 1 (0 points)

I cannot get a time card formula to work in numbers for iOS. I have looked all over excel and numbers forums and none of the formulas will work in my document. Please help.

 

An example of my setup:

 

Start 7:00

Lunch :30

End 16:30

  • Jerrold Green1 Level 7 Level 7 (29,855 points)

    Michael,

     

    I assume that you want to credit the worker for the number of hours between the start time and the end time and that you also want to subtract 30 minutes for the lunch break.

     

    If so, one way is to format all three data cell, and the result cell, as Duration. If there cells are A1, A2, A3, and A4, you would have an expression in A4:

     

    =A3 - A1 - A2

     

    Jerry