I want to keep track of hours worked and need a column to automatically calculate hours and minutes each day but when I want to add times, it gives me an error when using basic formula i.e. D2+D3
MacBook Pro 13″
If you want a positive result in a subtraction it's always big value - small value, therefore Clock out - Clock In, or E2 - D2, 19 - 18.
Since the values are times, the format should be time, not text, although Numbers is smart enough to see that you have times there. The result is a duration. All three cells can be set to Automatic and Numbers will take care of the rest.
If you want a positive result in a subtraction it's always big value - small value, therefore Clock out - Clock In, or E2 - D2, 19 - 18.
Since the values are times, the format should be time, not text, although Numbers is smart enough to see that you have times there. The result is a duration. All three cells can be set to Automatic and Numbers will take care of the rest.
The built-in templates in Numbers (File > New brings up the template chooser) often provide helpful working examples of how to address common problems.
For this one I recommend having a look at the 'Employee Schedule' template. Slightly simplified it looks something like this:
=IF(OR(ISBLANK(C2),ISBLANK(D2)),DURATION(0), D2−C2)
Note how it accounts for the common problem of having blank cells that are gradually filled in over time.
SG
Column F2 formula is =D2-E2 enter and it is giving me a negative result
both column D & E are formatted to Text and column F to Automatic, I also tried changing the format to Duration but it gives me an error. I don't have empty cells between the calculations
That part should be pretty easy and straightforward.
Is the problem when you finish past midnight, or when you add empty cells?
Show the error itself and more of your table.
How to calculate hours worked in Numbers (not excel) 24 hr clock
