how to convert time to decimal format

  • Thread starter Thread starter yolly
  • Start date Start date
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
 
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.
 
I need to convert 1 hour 38 min to decimals
Click to expand...

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
 
Back
Top