summing cells of Time

D

Don Scarbrough

I got an answere to my other message but the trouble is it
did not work -- --when summing a group of cells that have
time in then the help says use this formula =Sum
(cell:cell) if it is to be more than 24 hours the formula
is =sum(cell:cell)*24 the trouble is nomater how I
format the cells it still comes up either 0 or 0:00
 
F

Frank Kabel

Hi
format your target cell with the custom format [hh]:mm to prevent the
rollover after 24 hours
 
Top