I am trying to develop a spreadsheet to schedule production batches. With some help from the group I have been able to get cells to predict completion times based on a start time and duration.

My current problem is that the duration time is a value calculated from the average parts per hour and the batch size i.e. 200 at 28/hr = 7.1 hours. this is a general number but requires to be in time format for the completion time to be calculated. If I format the cell to hh the value changes to 03

How can I get the general format result of the duration calculation into a time format that can be added to a cell formatted ddd hh:mm to give a result in ddd hh:mm

Hope that makes sense

Thanks in anticipation of any assistance

Martin