| Home |
| Search |
| Today's Posts |
|
#1
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. |
| 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) | |||
Threaded Mode
