convert 7h 40.80n into time format

T

Todd

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
 
R

Ron Rosenfeld

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
Click to expand...

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
 
Top