how to convert time to decimal format

[yolly]

I need to convert 1 hour 38 min to decimals

 

[Bernard Liengme]

If cell A1 displays 1:30 , then the formula =A1*24 will display 1.5 when it
if formatted general
Likewise 1:38 gives 1.63
Does this answer the question?
best wishes

 

[trip_to_tokyo]

EXCEL 2007

1. Put 01:38:00 into cell H 13 (or any cell you like).

2. Cell H 15 format as General (right click cell / Format Cells . . . /
Format Cells window should launch / Number tab / General / OK)

Now in cell H 15 put:-

=H13

This will return 0.0680556 (the decimal you require).

If my comments have helped please hit Yes.

Thanks.

 

[Lars-Åke Aspelin]

I need to convert 1 hour 38 min to decimals

If you have the string "1 hour 38 min" in cell A1 and want to have the
decimal value 1+38/60 in some other cell, try this formula:

=1+38/60

If you want the formula to work also for other strings with a similar
format, i.e. first a number then the word " hour", then a second
number, then the word " min", then you can try this formula:

=LEFT(A1,FIND(" ",A1)-1)+MID(A1,FIND("hour",A1)+4,
FIND("min",A1)-FIND("hour",A1)-4)/60

Hope this helps / Lars-Åke

 

[Naftoli]

I have made up an "Excel Time sheet calculator".
You can downloaded for free from this link:
http://www.e-junkie.com/shop/product/329685.php
Sincerely
(e-mail address removed)