I don't quite understand. If your cells are formatted for time as it
seems, what kind of answers are you getting when the individual values
should add to more than 24 hours? For the example, if you have several
cells formatted as time and enter 10:00 & 19:00 and add the times you
get 5:00 which is the correct clock time 19 hours after 10 o'clock. It
does not give you 29 hours as you would expect if were adding 10 HOURS &
19 HOURS. The example you gave, "-3:31", is not a TIME which Excel
expects in that cell, but a DURATION of 3 hours and 31 minutes; there
is no -3:31 o'clock.


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=542709