-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
04/04/2018
-
L
Using excel to calculate hours open without double counting overlaps
Hi, I hope someone will be able to help me please. I am trying to work out how long a community centre is open each day. In Column A I have the date, in Column B I have the start time of a booking, in Column C I have the end time of the booking, Column D is the unique hours to count. I want...- lizgraham90
- Thread
- 04/04/2018 05/04/2018 column hours time
- Replies: 9
- Forum: Excel Questions
-
L
Using excel to calculate hours open without double counting overlaps
Hi, I hope someone will be able to help me please. Ok I am trying to work out how long a community centre is open each day. In Column A I have the date, in Column B I have the start time of a booking, in Column C I have the end time of the booking, Column D is the duration of the booking. I...- lizgraham90
- Thread
- 04/04/2018 booking column open time
- Replies: 3
- Forum: Excel Questions
-
N
Populating a table in excel to assess missing timesheet submissions
Hello, I am attempting to set up table which will allow me to assess employees who have not submitted a time-sheet. The raw data is as follows <tbody> Employee Number Employee Date Hours 1 Mr A 03/04/2018 8.00 1 Mr A 04/04/2018 8.00 1 Mr A 05/04/2018 8.00 5 Mr B...- Northster
- Thread
- 03/04/2018 04/04/2018 05/04/2018 mrs table
- Replies: 2
- Forum: Excel Questions
