| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I multiply an hourly cost by hours expressed in minutes?
I got a very long worksheet with tasks times in minutes (00:12 for 12 minutes
or 01:36 for 1 hour and 36 minutes), and hourly charge rates. I need to work out the cost in £ of those fractions of hours (and sometimes longer than one hour as you can see). I can't get the answer I look for. For example: a time cell has 00:12, and the hourly rate is 155, I should get to the 31 cost forthe 12 minutes, but can't. Any ideas? Thank you very much |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours and minutes | Excel Worksheet Functions | |||
| Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| elseif formula | Excel Discussion (Misc queries) | |||
| Help for a newbie trying to add hours and minutes :) | Excel Discussion (Misc queries) | |||
Threaded Mode
