Forum Discussion

Harreid's avatar
Harreid
Copper Contributor
Nov 30, 2019

Time formula

Can anybody please give me the formula to make this work. I have tried for many hours and just can't get it. Thank you for any help.   DATE TIME COME TIME GO HOURS WORKED 1     0:00:00 ...
excel
Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Nov 30, 2019

Harreid 

You may try this...

 

In D2

=IF(OR(B2="",C2=""),"",MOD(C2-B2,1))

and then copy it down.

  • Harreid's avatar
    Harreid
    Copper Contributor
    Nov 30, 2019
    Thank you so much for taking the time to help, much appreciated. I will try and see how it goes. Thanks again.