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

=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

Martin,

You are calculating the decimal number of hours, not in time. Time is stored
as a fraction of 1 day, so hours is held as .3333333 for instance. So you
need to convert that 7.1 to the same decimal type, and to do that you need
to divide by 24 (24 hours in 1 day).

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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