software

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

Hi,

If the military time is in A1 and B1 contains the number of minutes you want
to add to A1, use the formula,
=A1 B1/1440

If B1 contains not just a number (e.g., 35) but a number followed by quot; minquot;
(e,g.,quot;35 minquot;), use the following formula,
=A1 TRIM(LEFT(B1,FIND(quot;mquot;,B1)-1))/1440

In either case, format C1 for military time.

Regards,
B. R. Ramachandran

quot;SteveTALLquot; wrote:

gt; How do I add military time from one cell with minutes from another cell and
gt; also show the change in the hours?
gt;
gt; aka....0600 and add 60 min to make 0700....and 0635 add 35 min to make 0710
gt;
gt; thanks in advance

One way

=--TEXT(TEXT(A1 B1,quot;00\:00quot;),quot;hhmmquot;)

format as 0000

--Regards,

Peo Sjoblomquot;SteveTALLquot; gt; wrote in message
...
gt; How do I add military time from one cell with minutes from another cell
gt; and
gt; also show the change in the hours?
gt;
gt; aka....0600 and add 60 min to make 0700....and 0635 add 35 min to make
gt; 0710
gt;
gt; thanks in advance