How to calculate time after converting 12.22 to 12:22

B

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)
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing 1-2 caharacters 1
an if( statement looking for a specific phrase anywhere in a cell 3
Nested IF functions beyond eight items? 3
if function and ifblank() function 3
ranking based on criteria 1
How do I have excel highlight days before & after a date on a cale 2
Need to sum "last 5" red cells 7
If Statement - in time not decimal minutes 1

Top