Prev: convert 200701 to Jan-07
Next: Column Lookup?
From: yolly on 14 May 2010 12:32
I need to convert 1 hour 38 min to decimals
From: Bernard Liengme on 14 May 2010 12:44
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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"yolly" <yolly(a)discussions.microsoft.com> wrote in message
news:B116FEAB-FFE2-402C-A3F0-5061D819BEB1(a)microsoft.com...
> I need to convert 1 hour 38 min to decimals

From: trip_to_tokyo on 14 May 2010 12:53
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.





"yolly" wrote:

> I need to convert 1 hour 38 min to decimals
From: Lars-�ke Aspelin on 14 May 2010 13:05
On Fri, 14 May 2010 09:32:01 -0700, yolly
<yolly(a)discussions.microsoft.com> wrote:

>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

From: Naftoli on 14 May 2010 16:01
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
Naftoli(a)bestwayphonecards.com



"yolly" wrote:

> I need to convert 1 hour 38 min to decimals
 | 
Pages: 1
Prev: convert 200701 to Jan-07
Next: Column Lookup?