Turning durations in hh:mm:ss into costs

C

Casi

New member
Joined
Oct 10, 2013
Messages
6
Reaction score
0
Points
0
Hi there

I have an export that shows me duration against task in hh:mm:ss. I need to work out the cost of that time. Eg, if one hour costs $50, then how much does 00:20:14 cost?

Thanks

Casi
 
Try:

=(A2*24)*50

you can replace the 50 with cell reference containing the unit cost.
 
You must log in or register to reply here.
Back
Top