View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bytor Bytor is offline
external usenet poster
 
Posts: 1
Default cumulative time in excel

I am trying to format a cell that will add all of the times I input in a
vertical column. Those cells are in [h]:mm so that it can exceed 24 hours. It
all works well except when I try to enter a negative value into the equation.
If I add 10 minutes in one cell to 30 minutes in another cell, and then have
another cell that has -5 minutes, my total time does not equal 35 minutes.
Any suggestions?