Hi Guys,
I am trying to calculate the approximate hours worked by staff in a restaurant. The business operates in two shifts which ran from 9:30am to 4pm and then 6pm to close on Wednesday to Saturday and 9:30am to close on Sundays. Note that the start and finish times could have varies by circa one hour either side of the hours mentioned and that the close time could have been on the following day
I have all of the transactions from the tills and my plan is to simply take the time of the first and the last transactions to determine the hours. I have used a formula which calculates the hours on the early shift but because the late shift goes over to the next day I am unable to pick up the last working hour of the day and so unfortunately a min max function in isolation won't work.
I'd be super grateful for any help that you can give me.
Thanks in advance
I am trying to calculate the approximate hours worked by staff in a restaurant. The business operates in two shifts which ran from 9:30am to 4pm and then 6pm to close on Wednesday to Saturday and 9:30am to close on Sundays. Note that the start and finish times could have varies by circa one hour either side of the hours mentioned and that the close time could have been on the following day
I have all of the transactions from the tills and my plan is to simply take the time of the first and the last transactions to determine the hours. I have used a formula which calculates the hours on the early shift but because the late shift goes over to the next day I am unable to pick up the last working hour of the day and so unfortunately a min max function in isolation won't work.
I'd be super grateful for any help that you can give me.
Thanks in advance