Thread
:
Please help with time calculation
View Single Post
#
1
[email protected]
Posts: n/a
slightly shorter option
=(B1-A1)*24+IF((B1-A1)*24<0,24,0)
=(B1-A1+(A1B1))*24
hth RES
Reply With Quote