How to calculate time after converting 12.22 to 12:22

[Bob Phillips]

=A2*24*10

that is multiply the time by 24


--
HTH

Bob Phillips

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

 

[Mouimet]

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.