lewerjason
New member
- Joined
- Oct 12, 2017
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi, I'm looking for a formula for finding the time spent away from desk. Can someone help. I need to know how much time was spent outside. Below is the sample log
| 9/1/2017 00:40:01 | Exit granted |
| 9/1/2017 00:44:11 | Entry granted |
| 9/1/2017 01:10:36 | Exit granted |
| 9/1/2017 01:19:11 | Entry granted |
| 9/1/2017 01:20:21 | Exit granted |
| 9/1/2017 01:38:30 | Entry granted |
| 9/1/2017 01:46:42 | Exit granted |
| 9/1/2017 01:50:03 | Entry granted |
| 9/1/2017 02:49:09 | Exit granted |
| 9/1/2017 02:59:28 | Entry granted |
| 9/1/2017 03:11:00 | Exit granted |
| 9/1/2017 03:12:58 | Entry granted |
| 9/1/2017 03:16:22 | Exit granted |
| 9/1/2017 03:20:44 | Entry granted |
| 9/1/2017 03:42:37 | Exit granted |
| 9/1/2017 18:53:53 | Entry granted |
| 9/1/2017 19:03:36 | Exit granted |
| 9/1/2017 19:03:44 | Entry granted |
| 9/1/2017 19:03:55 | Exit granted |
| 9/1/2017 19:24:48 | Entry granted |
| 9/1/2017 19:31:29 | Exit granted |
| 9/1/2017 19:38:11 | Entry granted |
| 9/1/2017 19:38:30 | Exit granted |
| 9/1/2017 20:12:19 | Entry granted |
| 9/1/2017 20:31:15 | Exit granted |
| 9/1/2017 20:49:09 | Entry granted |
| 9/1/2017 22:30:03 | Exit granted |
| 9/1/2017 22:32:40 | Entry granted |
| 9/1/2017 23:15:42 | Exit granted |
| 9/1/2017 23:30:13 | Entry granted |
| 9/2/2017 00:57:39 | Exit granted |
| 9/2/2017 00:57:45 | Entry granted |
| 9/2/2017 00:58:18 | Exit granted |
