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