Would appreciate your help to get a solution
We have 6 desktops in our café for which I have the usage time logged in “Start Time” & “End Time” (without dates, in 24 hr format, goes over midnight 00:00 hrs)
Column A Column B
Start Time End Time
21:37:48 22:47:55
21:37:54 21:59:43
21:53:09 22:10:28
22:10:24 23:30:20
22:17:09 22:57:33
22:49:20 23:24:26
22:57:22 01:42:56
00:23:04 01:12:01
00:23:10 02:16:40
01:12:31 02:18:32
01:44:36 02:21:06
03:15:44 03:32:57
03:27:57 04:47:20
03:29:07 03:53:10
Our requirement is to get the duration for which systems were utilized simultaneously for a day (Evening till next day early morning)
Duration for which 1 system was utilized: ?
Duration for which 2 systems were utilized simultaneously: ?
Duration for which 3 systems were utilized simultaneously: ?
Duration for which 4 systems were utilized simultaneously: ?
Duration for which 5 systems were utilized simultaneously: ?
Duration for which 6 systems were utilized simultaneously: ?
We have been raking our brains for a week now. Would appreciate if you can help us out.
Thanks
Nin
Bookmarks