Hi,

I was hoping that somebody would be able to help me. I am currently trying to set up a time sheet log and require some help.

I work in a shopping centre, and we are trying to log stores who open late and close early. We would like to have this on a spreadsheet that is easy to use, as it will be different security officers filling this in.

On the spreadsheet we are currently using, all of the stores are listed in column A, and then we have the days of the week in the following columns. In the row below each day has two columns, titled "open time" and "close time"
We only put the time in, if they have opened late or closed early. Stores that trade to time are not logged.

I would like a spreadsheet that allows us to show how much time stores have lost in trade due to open late/closing early, and we would like to collate this on a weekly/monthly basis.

I hope that somebody is able to help me!

Thanks for taking your time to read my gibberish!!