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

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)


"Malcolm Judge" <Malcolm wrote in message
...
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