Calculate time
Hello
With =sum I don't want to calculate total?
Should I use another formula?
Thank you
Ryszard
[Re-Titled by Moderator]
MacBook Air 13″
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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hello
With =sum I don't want to calculate total?
Should I use another formula?
Thank you
Ryszard
[Re-Titled by Moderator]
MacBook Air 13″
Hi ryszard,
For the SUM (SOM) function in F11, Column F must be all the same units (Duration), not zeroes (Numbers).
Formula in F2 is IF(OR(D2="",E2=""),DURATION(,,hours,minutes,seconds),E2−D2)
Fill down.
Regards,
Ian.
Hello Yellowbox
Thanks for your help!!!!!!
Calculate time