H Harald Staff Oct 10, 2004 #3 =B1-A1+(B1<A1) og if you insist on formatting the result as requested =(B1-A1+(B1<A1))*24&"HR'S" HTH. Best wishes Harald
=B1-A1+(B1<A1) og if you insist on formatting the result as requested =(B1-A1+(B1<A1))*24&"HR'S" HTH. Best wishes Harald
R Richard - ExcelForums.com Oct 10, 2004 #4 =IF(B1>A1, B1-(A1-"00:00:01"), A1-(B1-"00:00:01") I use this. Always keeps the time positive. i.e. 4am -> 1am woul be 3 hours The addition of seconds is becuase sometime Excel thought 11am minu 11am would be a negative number
=IF(B1>A1, B1-(A1-"00:00:01"), A1-(B1-"00:00:01") I use this. Always keeps the time positive. i.e. 4am -> 1am woul be 3 hours The addition of seconds is becuase sometime Excel thought 11am minu 11am would be a negative number
M TO 1:00AM = 2HR'SM TO 1:00AM = 2HR'S
M TO 1:00AM = 2HR'S