How to calculate time after converting 12.22 to 12:22
 

=A2*24*10

that is multiply the time by 24


--
HTH

Bob Phillips

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

"Mouimet" wrote in message
...
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.

How to calculate time after converting 12.22 to 12:22
 

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.