Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time conversion
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time conversion
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 "SteveTALL" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time conversion
One way
=--TEXT(TEXT(A1+B1,"00\:00"),"hhmm") format as 0000 -- Regards, Peo Sjoblom "SteveTALL" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time and motion chart | Charts and Charting in Excel | |||
Time To Leave | Excel Discussion (Misc queries) | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Excel Time Conversion | Excel Discussion (Misc queries) |