How to calculate hours worked in Numbers (not excel) 24 hr clock

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″

Posted on Dec 6, 2023 11:16 AM

Reply
Question marked as Top-ranking reply

Posted on Dec 6, 2023 12:42 PM

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.

Similar questions

4 replies
Question marked as Top-ranking reply

Dec 6, 2023 12:42 PM in response to AdriDR

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.

Dec 6, 2023 9:00 PM in response to AdriDR

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

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to calculate hours worked in Numbers (not excel) 24 hr clock

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.