Addition problem

  • Thread starter Thread starter Mike
  • Start date Start date
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.
 
Hi
try formating the cell with the custom format
[hh]:mm

or try the format
D hh:mm
 
Custom format [hh]:mm

--
Regards,

Peo Sjoblom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top