Lean Manufacturing Blog » Lean Manufacturing » Excel time function for production planning?
Excel time function for production planning?
Sajid R asked:
Hi I am doing a spreadsheet for production planning. In 8 hrs day, production are allowed for 45mins break. 15 mins at 1000am in the morning and than lunch break at 1300pm. I want spread sheet to add 15 mins if it is in the morning and add 30mins when the time is 1300.
Please help
Thanks
Dear Bill7570
Thanks for your reply. Apologise for not making it clear. I have the formula in this way
in cell a I have start time of the job which is 08:00:00 (i.e. 8am) this particular job take 3hrs to complete which is 11:00:00 but I want to refelect 15 mins break. So I want the end time to display 11:15:00. And if the job will take more than 5 hrs than it will finish at 13:00:00 but I want the cell the display 13:45:00 (15mins of morning break, 30 mins of luch break plus 5 hrs of actual working time). I hope this will make sense and you will be able to help
Thanks
Hi I am doing a spreadsheet for production planning. In 8 hrs day, production are allowed for 45mins break. 15 mins at 1000am in the morning and than lunch break at 1300pm. I want spread sheet to add 15 mins if it is in the morning and add 30mins when the time is 1300.
Please help
Thanks
Dear Bill7570
Thanks for your reply. Apologise for not making it clear. I have the formula in this way
in cell a I have start time of the job which is 08:00:00 (i.e. 8am) this particular job take 3hrs to complete which is 11:00:00 but I want to refelect 15 mins break. So I want the end time to display 11:15:00. And if the job will take more than 5 hrs than it will finish at 13:00:00 but I want the cell the display 13:45:00 (15mins of morning break, 30 mins of luch break plus 5 hrs of actual working time). I hope this will make sense and you will be able to help
Thanks
Filed under: Lean Manufacturing · Tags: Apologise, Excel Function, Spreadsheet, Time Function, Working Time
One Response to "Excel time function for production planning?"
Leave a Reply
Follow Me
Recent Comments
- andrewjparke on Question on Toyota Corp?
"LEAN- removal of MUDA ( waste) from all parts of the process. Toyota famous for …" - F. Pujol Crespell on The Toyota Production System Re-contextualized
"The book starts with a short history of Toyota, with anecdotes that help better …" - Rick Tuttle on Rath & Strong’s Six Sigma Pocket Guide: New Revised Edition
"I have been a long time Rath & Strong pocket guide customer and was uneasy with …" - Robert Morris on Rath & Strong’s Six Sigma Pocket Guide: New Revised Edition
"What we have here in a single volume (in a new revised edition) is a focus on "t…" - da perfesser on Rath & Strong’s Six Sigma Pocket Guide: New Revised Edition
"I've been using this little pocket guide for years in my practice as a Six Sigma…"
Not quite sure how you are representing time in your spreadhseet (i.e. do you have time values in a row or column) but I think it’s the TIMEVALUE function that you want to looking at. For example, if the time you want to check is in row 1 then function might be something like =if(timevalue(a1)> timevalue(“10:00″),… add 15 minues…, do nothing)
sorry if this doesn’t make exact sense but without a more detailed descripion of what you are doing it’s tricky!!