Thread
:
Calculating time difference
View Single Post
#
3
Max
Posts: n/a
Put in say, C1: =(B1-A1)/24
The above presumes B1 will always be =A1
Perhaps a more apt formula could be:
=IF(A1<B1,(B1-A1)/24,"")
which'll return blanks: ""
if A1=B1
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Reply With Quote