Time conversion

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SteveTALL - 17 Dec 2005 18:11 GMT

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

Reply to this Message

B. R.Ramachandran - 17 Dec 2005 18:41 GMT

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 " min"
(e,g.,"35 min"), use the following formula,
=A1+TRIM(LEFT(B1,FIND("m",B1)-1))/1440

In either case, format C1 for military time.

Regards,
B. R. Ramachandran

> 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

Reply to this Message

Peo Sjoblom - 17 Dec 2005 19:16 GMT

One way

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

format as 0000

Signature

Regards,

Peo Sjoblom

> How do I add military time from one cell with minutes from another cell
> and
[quoted text clipped - 4 lines]
>
> thanks in advance

Reply to this Message