From a previous post this week:
One way

=--TEXT(TEXT(A1+B1,"00\:00"),"hhmm")

format as 0000

Peo Sjoblom

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"SteveTALL" wrote in message
...
I am looking for a way to calculate military time by adding minutes and
coming up with a new military time. For example, in one cell military
time
is posted '0645....then next cell for minutes is posted 25 minutes. I
would
like the next cell to post 0710. How can that be done?

Thanks in advance.