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.

RKocha Author

Level 1

4 points

Number

Hey guys, So in this scenario if there's no hours worked how do I keep the cell "Blank"? because there's a zero, my total hours formula isn't working.

Would love to get some help on this.

Thanks in advance.

MacBook Pro 13″, macOS 10.14

Posted on Oct 12, 2023 10:16 PM

Top-ranking reply

SGIII

Level 8

36,278 points

Posted on Oct 12, 2023 11:32 PM

You can do something like this:

In D2, filled down:

=IF(OR(ISBLANK(B2),ISBLANK(C2)),DURATION(0), C2−B2)

You can see a working example of this approach in column E of the 'Sign In ' table of the 'Employee Schedule' template at File > New in your menu.

Use ; instead of , in the formula if your regions uses , as the decimal formula.

View in context

1 reply