Excel time function for production planning?
Friday, November 27th, 2009 at
3:40 pm
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
Tagged with: Apologise • Excel Function • Spreadsheet • Time Function • Working Time
Filed under: Lean Manufacturing
Like this post? Subscribe to my RSS feed and get loads more!
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!!