Thread: Time conversion
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Time conversion

One way

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

format as 0000

--


Regards,

Peo Sjoblom


"SteveTALL" wrote in message
...
How do I add military time from one cell with minutes from another cell
and
also show the change in the hours?

aka....0600 and add 60 min to make 0700....and 0635 add 35 min to make
0710

thanks in advance