Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Military Time
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Military Time
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" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) | |||
Time and motion chart | Charts and Charting in Excel | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
in excel totaling weekly hours military time | Excel Worksheet Functions |