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″
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.