Hi,
I am needing help adding a column of time.
I have one column - column c addin up the difference between times. If
nothing is entered in a & b then the column displays 0:00. This is
giving me a value of 24 hrs instead of being zero. The problem comes
in when I add up column c. It is taking the values plus the 0:00 (as
24) and adding all of these values.
ex: one entry is 12, one entry is 6, one entry is 0:00
the total that is computed is 42 and not 18
I would need the 0:00 to remain as 0:00. Can anyone help me with this?
--
rvnwdr
------------------------------------------------------------------------
rvnwdr's Profile:
http://www.excelforum.com/member.php...o&userid=23903
View this thread:
http://www.excelforum.com/showthread...hreadid=380049