=7.1/24

will give you the excel time value


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Martin B" wrote in message
...
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