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.

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

Kaoki Author

Level 1

4 points

Can not calculate time and duration on numbers.

I would like to make time management sheet on numbers.

But when I calculate working hours, they shows the error " The operator "_" can't subtract a date from a number. "

I am using Numbers version 10.3.5 (7029.5.5)

A: Date, B: Starting time, C: Break time, D: End time, E: Working hour.

I put like this: B2( 9:00), C2(0:30), D2(17:00), E2(=D2-B2-C2)

then for the cell format, either B2, D2 are Date&Time and C2 is Duration or all of them are Time and Duration, the calculation is not going well. Always shows the error message.

I have no idea why its not going well. Please help me out. Or give me some ideas to make it better.

Thank you,

MacBook Air 13″, OS X 10.10

Posted on Sep 19, 2021 4:27 AM

Top-ranking reply

Yellowbox

Level 7

21,197 points

Posted on Sep 19, 2021 7:27 AM

Hi Kaoki,

Numbers may be misinterpreting 0:30 as a time of day, not a Duration. Format the Break column like this and enter 30m instead of 0:30

Regards,

Ian.

View in context

Can not calculate time and duration on numbers.

Similar questions