Excel time function for production planning?

Question

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

Answer 1

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!!