Wolfster63
New Member
- Joined
- May 2, 2018
- Messages
- 24
I have a large spreadsheet that shows the in and out times of our surgical unit. I would like to construct a pivot table that would show if
a operating room is being use during a given time of a day. The goal would be to eventually look at average room use over a given span of days to see when certain rooms are more likely to be unoccupied so as to figure good times and days to let a surgeon have a room regularly scheduled for him.
Here is a basic structure of the spread sheet:
<tbody>
</tbody>
Have tried several permutations, with results,
Any broad ideas or approaches I could try?
Thanks,
Will
a operating room is being use during a given time of a day. The goal would be to eventually look at average room use over a given span of days to see when certain rooms are more likely to be unoccupied so as to figure good times and days to let a surgeon have a room regularly scheduled for him.
Here is a basic structure of the spread sheet:
Room Number | Start Date/Time | End Date/Time | Start Time | End Time |
OR1 | 01/02/18 07:00 | 01/02/18 10:03 | 7:00 | 10:03 |
OR2 | 01/02/18 07:09 | 01/02/18 08:32 | 7:09 | 8:32 |
OR3 | 01/02/18 07:30 | 01/02/18 08:21 | 7:30 | 8:21 |
OR4 | 01/02/18 07:30 | 01/02/18 10:02 | 7:30 | 10:02 |
OR5 | 01/02/18 07:32 | 01/02/18 10:10 | 7:32 | 10:10 |
OR6 | 01/02/18 07:58 | 01/02/18 08:36 | 7:58 | 8:36 |
OR7 | 01/02/18 13:11 | 01/02/18 18:32 | 13:11 | 18:32 |
OR8 | 01/02/18 13:32 | 01/02/18 16:33 | 13:32 | 16:33 |
OR9 | 01/02/18 17:00 | 01/02/18 18:13 | 17:00 | 18:13 |
OR1 | 01/02/18 10:29 | 01/02/18 10:58 | 10:29 | 10:58 |
OR2 | 01/02/18 08:37 | 01/02/18 09:14 | 8:37 | 9:14 |
OR4 | 01/02/18 12:32 | 01/02/18 14:17 | 12:32 | 14:17 |
OR5 | 01/02/18 19:31 | 01/02/18 20:34 | 19:31 | 20:34 |
OR6 | 01/02/18 14:22 | 01/02/18 15:28 | 14:22 | 15:28 |
OR7 | 01/02/18 19:06 | 01/02/18 22:39 | 19:06 | 22:39 |
<tbody>
</tbody>
Have tried several permutations, with results,
Any broad ideas or approaches I could try?
Thanks,
Will