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