P
Pheasant Plucker®
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?
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?