| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert 7h 40.80n into time format
I need to convert a column of time information from its curent format to one
excel formulas can read. what I have now is : 7h 40.80n (7 hours 40.8 minutes) any ideas? Todd |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert 7h 40.80n into time format
On Tue, 8 Aug 2006 16:39:01 -0700, Todd wrote:
I need to convert a column of time information from its curent format to one excel formulas can read. what I have now is : 7h 40.80n (7 hours 40.8 minutes) any ideas? Todd Assuming your format is as you describe above, then =LEFT(A1,FIND("h",A1)-1)/24+MID(A1,FIND("h",A1)+2,LEN(A1)-FIND("h",A1)-3)/1440 should work. If the format is more variable, post back with some of the variations. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert time format to a decimal | Excel Worksheet Functions | |||
| Convert data into standard military time format | Excel Discussion (Misc queries) | |||
| Excel should format time down to the hundredth/sec. | Excel Discussion (Misc queries) | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
| convert number to time format? | Excel Discussion (Misc queries) | |||
Hybrid Mode
