Displaying Hours, Minutes & Seconds

Hi

I'm new to this forum so please forgive me if this has been asked before. I am producing a MRP (Material Requirement Plan) spreadsheet for work. As part of this I have been asked to look at the man hours required in order to achieve the production targets.

Each product we produce has a costing sheet, which is on an excel spreadsheet. From this I have extracted the total labour recovery in £'s. Our hourly labour rate for production is £11.85 per hour or £0.1975 per minute. So what I'm doing is dividing the total labour recovery in £'s by £0.1975 (the value of 1 minute of production time).

For example one product we produce has £0.85 total labour recovery; if I divide this by £0.1975, the result is 4.3 minutes. But I don't want to display it like this I want to display it as 4 minutes 18 seconds. I've tried all the the 'custom' formats such as hh:mm:ss; mm:ss etc etc.. but to no avail..... I've found people asking similar questions on other forums, but not really any satisfactory answers, people seemed to getting confused between displaying hours in the day and time taken to complete a task. I want to represent the later. Any ideas?

Thanking you in advance
Kevin

If you have the hourly rate in A4, i.e. £11.85 and the "total labour recovery" in B4, i.e. 0.85 then you can use this formula in C4

=B4/A4/24

format C4 as h:mm:ss and you get 0:04:18

Thanks so much for that. I just inputted the formula you said and it has worked a treat. Fantastic! Thanks again
Kevin