Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate total service time in excel | Excel Discussion (Misc queries) | |||
How to calculate Date & Time differences | Excel Worksheet Functions | |||
HOW DO I CALCULATE TIME IN A TIME SHEET FOR EXCEL | New Users to Excel | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) |