How can I add up time, say 18:00 + 18:00 hrs in excel 2002

M

Malcolm Judge

No probs subtracting times, but try to add them does not seem to work for me.

Subtracting times: e.g. (cells are formatted in Time, i.e. 4:00:00 AM
4:00:00 AM 12:30:00 PM =TEXT(D5-C5,"h:mm") this formula works

Adding times: can anyone help please
 
B

Bob Phillips

Firstly, when subtracting, D5-C5 works fine, just format the cell as time,
you don't need TEXT.

When you add, if it goes above 24 hours it errors. Just change the format to
[hh]:mm

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top