Hi,

since this spreadsheet will be used by several users the 1904 solution
won't be practical although it indeed works great.

The time calculations are not date-dependent so perhaps there is a
better solution then adding or subtracting a day?
I could for example subtract an additional 4:00 hours, but will that
always work?

=IF(A2 A1,A1 + 1 - A2 - 4/24,A1 - A2)

doesn't work since it will return 11:00 if A1=1:00 and A2=10:00.

The result should be the difference between A1 and A2;

A1=10:00
A2=0:00
A3=10:00

A1=0:00
A2=0:00
A3=0:00

A1=5:00
A2=6:00
A3=-1:00

A1=6:00
A2=5:00
A3=1:00

thanks so far!


--
Pantryman
------------------------------------------------------------------------
Pantryman's Profile: http://www.excelforum.com/member.php...o&userid=15233
View this thread: http://www.excelforum.com/showthread...hreadid=320065