Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Substacting two military times
I would like to be able to substract entry of two military times and come up with the difference in Hours and tenths of an hour. Example 0945-0800 = 145 converted to 1.75 hours.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Substacting two military times
Hi Jake!
If you have your calculations in the form shown: =(TIME(LEFT(A13,2),MID(A13,3,2),0)-TIME(MID(A13,6,2),RIGHT(A13,2),0))* 24 The Time functions use the syntax TIME(Hour, Minute, Second) The text parsing functions LEFT, MID and RIGHT are extracting the arguments for the TIME function The result has to be multiplied by 24 since Excel treats time as a decimal part of 1 day. If you have your times in different cells you should be able to adapt the above. For Excel's handling of time generally see: http://www.cpearson.com/excel/datetime.htm#TOC -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Jake Swarty" wrote in message ... I would like to be able to substract entry of two military times and come up with the difference in Hours and tenths of an hour. Example 0945-0800 = 145 converted to 1.75 hours. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Substacting two military times
On Mon, 15 Dec 2003 14:21:08 -0800, "Jake Swarty" wrote:
I would like to be able to substract entry of two military times and come up with the difference in Hours and tenths of an hour. Example 0945-0800 = 145 converted to 1.75 hours. With 0800 in A1 and 0945 in A2: =DOLLARDE(A2/100,60) - DOLLARDE(A1/100,60) If the DOLLARDE function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a stacked bar chart using military times? | Charts and Charting in Excel | |||
Working with times in military/international format. | Excel Discussion (Misc queries) | |||
How do I caculate 24 hour military times | Excel Worksheet Functions | |||
Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions |