Try

=(TIME(INT(LEFT(A1,2)),INT(MID(A1,5,2)),INT(RIGHT( A1,5)))+(INT(LEFT(A1,2)/24)))*24


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Demi" wrote in message
...
i have data in the form 90° 58' 12.00" W for latitudes and
longitudes. The
data is huge and so I need to have a formula to convert this
data in decimal
form like 90.xxxx .
I tried cpearson website but it asks me to enter the data in
h:mm:ss form,
the problem is i already have the data as shown above and i
would like to
know how to get it converted to decimals directly so that I can
drag the
formula for the entire column.
Thanks

demi