Can't calculate actual hours and costs from standard

[Ochimus]

Apologies as this must have been covered before, but I can't find it.

Plant produces ten widgets per hour at labour rate of £15 per hour

Customer orders sixty widgets, so it will take six hours and cost £90

Can't see the formula to put into B9 to get "06:00", and then the formula in B11 that will multiply the hourly rate by the six hours to get the £90

All suggestions and pointers accepted gratefully as ever

Ochimus

[JohnTopley]

Time taken

=B7/B5/24 (format as h:mm)

Cost

=B3*B9*24

[Ochimus]

John,

Many thanks for prompt solution, enabling me to mark this as "solved".

Trust you'll be rewarded with an excellent Christmas.

Ochimus