Military Time:by adding minutes

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.

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" <SteveTALL@discussions.microsoft.com> wrote in message
news:F4D8BE76-BF4B-4E6E-985B-721242453D61@microsoft.com...
>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.

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


"SteveTALL" wrote:

> 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.