You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025

Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

tyc2010 Author

Level 1

8 points

Calculate 0h durations in a timesheet?

My job requires us to turn in timesheets for each pay period and I am trying to turn it digital to make it a little easier. In the process, I have gotten Numbers to calculate the durations I need unless there is no time present. If I don't have a clock in/out present, the calculation is 0 rather than 0h and it throws everything off. I tried changing the cell format to duration but when I click off the cell and go back to it, it changes back to automatic. I tried doing an if statement in the function but if I try to type any duration into the function (i.e. 0h) it simply won't let me. Is there a way to get the calculation to default to 0h if there isn't a time present to calculate?