Military Time

[Guest]

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.

 

[Bernard Liengme]

From a previous post this week:

One way

format as 0000

Peo Sjoblom

best wishes

 

[Guest]

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.

PS: I had posted this reply to your previous post on the same question.

Regards,
B. R. Ramachandran