Addition problem

M

Mike

When I am adding time (example 22:00 + 03:00 = 1 day 2
hours) Excell will restart adding because the time went
over 24 hours. I need it to add the days or continue to
add the hours after it reaches 24 hours. Thank you for
ous help.
 
F

Frank Kabel

Hi
try formating the cell with the custom format
[hh]:mm

or try the format
D hh:mm
 
P

Peo Sjoblom

Custom format [hh]:mm

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top