| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate total cost using fixed hourly rate from [h:mm:ss:]?
Hi there,
I have a spreadsheet keeping track of time I spend on a project. The Total Time cell is formatted as Special and specified as [h:mm:ss:] I have a standard hourly rate and I would like to calculate the total time spent & display the result in Pounds Sterling - the cell is already formatted as Currency For example the Total Time is 10h:01mm:41ss: and I want to multiply this by the Hourly rate which is 30 Pounds Sterling. What is the formula to achieve this please? -- Thanks & kind regards, -pp- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mileage Claim Formula | New Users to Excel | |||
| multiply total hours by hourly pay | Excel Discussion (Misc queries) | |||
| Hourly rate times hours? | Excel Worksheet Functions | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| how to calculate total months from month/year | Excel Discussion (Misc queries) | |||
Threaded Mode
