=A2*24*10

that is multiply the time by 24


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mouimet" <(E-Mail Removed)> wrote in message
news:E6376239-3776-442D-8690-(E-Mail Removed)...
> First I'm trying to enter time (Hours.Minutes) like 12.22 or 123.54
instead
> of 12:22 and 123:54 for fast entries because I have many of them. Add all
of
> them after.
> I use the formula in cell A2: =INT(A1)/24+MOD(A1,1)/14.4 to convert in
time
> format([H]:mm
> Everything is working well until I want to multiply the results by money.
> Example: Data: 125.36 Results after converting: 125:36 If I add many
data
> the total of all hours and minutes are OK.
> Now I need to calculate a cost for: 125 hours 36 minutes.
> 125:36 * $10.00 = $10.35 (????)Format in money. This is not the right
> Answer. How to make it right
> Thank you.
>
>

First I'm trying to enter time (Hours.Minutes) like 12.22 or 123.54 instead
of 12:22 and 123:54 for fast entries because I have many of them. Add all of
them after.
I use the formula in cell A2: =INT(A1)/24+MOD(A1,1)/14.4 to convert in time
format([H]:mm
Everything is working well until I want to multiply the results by money.
Example: Data: 125.36 Results after converting: 125:36 If I add many data
the total of all hours and minutes are OK.
Now I need to calculate a cost for: 125 hours 36 minutes.
125:36 * $10.00 = $10.35 (????)Format in money. This is not the right
Answer. How to make it right
Thank you.