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.

How do I convert 30m duration to a format that can be used in a timevalue calculation?

I have two columns for times for start and end of a period, with a separate column with the equivalent Timevalue for each to enable me to subtract the start time from the end time. However I also have a column with a duration representing a break, and this is expressed as eg 30m. How do I subtract the break time from the calculation result for the Timevalue calculation?


I am currently using the formula below:


IFERROR(MOD(F12−B12,"1d")−D12,"")


But the problem here is it does not work when comparing across midnight. for example,


Start time = 21:40 (9.40pm) ==> Timevalue 0.4028

Break = 30m

End time = 09:50 (the next day) ==> Timevalue 0.4097


The answer I am expecting is 12h 10m - 30m = 11h 40m but what I get is -0h 20m.


Where am I going wrong?

Mac Studio, macOS 14.6

Posted on Aug 19, 2024 6:55 AM

Reply
1 reply

How do I convert 30m duration to a format that can be used in a timevalue calculation?

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