Forum Discussion

Zneta's avatar
Zneta
Frequent Visitor
2 years ago

Use Power Query to Subtract time frames form a complete day

Hello everybody,   There might be an easier solution to my problem, or to not do it in Power Query at all. Any help is appreciated:   I have a Dataset with start and end times like this: Start: ...
Need Help
Zneta's avatar
Zneta
Frequent Visitor
2 years ago

 

 

 

 

Thanks for the answers I will test all suggested solutions. As requested here is the data that i have. My expected result should be a timeframe in seconds where none of these timeframes happen.
Ideally i want to have a visual Timeline that displays the time frames in red and the times inbetween the given frames in green.

 

Start                                              End

5/14/2024 6:21:03 AM -05:005/14/2024 6:49:19 AM -05:00
5/14/2024 6:31:39 AM -05:005/14/2024 6:31:44 AM -05:00
5/14/2024 6:36:39 AM -05:005/14/2024 6:38:32 AM -05:00
5/14/2024 6:37:36 AM -05:005/14/2024 6:38:06 AM -05:00
5/14/2024 6:55:14 AM -05:005/14/2024 6:55:32 AM -05:00
5/14/2024 6:55:37 AM -05:005/14/2024 6:55:51 AM -05:00
5/14/2024 7:06:01 AM -05:005/14/2024 7:06:15 AM -05:00
5/14/2024 7:16:03 AM -05:005/14/2024 7:17:57 AM -05:00
5/14/2024 7:43:26 AM -05:005/14/2024 7:43:26 AM -05:00
5/14/2024 7:43:27 AM -05:005/14/2024 7:47:12 AM -05:00
5/14/2024 7:49:21 AM -05:005/14/2024 7:52:00 AM -05:00
5/14/2024 7:58:30 AM -05:005/14/2024 7:59:02 AM -05:00
5/14/2024 8:00:21 AM -05:005/14/2024 8:00:21 AM -05:00
5/14/2024 8:00:22 AM -05:005/14/2024 8:00:37 AM -05:00
5/14/2024 8:01:43 AM -05:005/14/2024 8:03:31 AM -05:00
5/14/2024 8:03:09 AM -05:005/14/2024 8:05:10 AM -05:00
5/14/2024 8:04:39 AM -05:005/14/2024 8:04:39 AM -05:00
5/14/2024 8:04:40 AM -05:005/14/2024 8:05:49 AM -05:00
5/14/2024 8:10:08 AM -05:005/14/2024 8:10:08 AM -05:00
5/14/2024 8:10:09 AM -05:005/14/2024 8:10:56 AM -05:00
5/14/2024 8:17:04 AM -05:005/14/2024 8:17:56 AM -05:00
5/14/2024 8:23:24 AM -05:005/14/2024 8:24:13 AM -05:00
5/14/2024 8:26:22 AM -05:005/14/2024 8:35:36 AM -05:00
5/14/2024 8:30:59 AM -05:005/14/2024 8:30:59 AM -05:00
5/14/2024 8:31:42 AM -05:005/14/2024 8:32:53 AM -05:00
5/14/2024 8:34:39 AM -05:005/14/2024 8:35:32 AM -05:00
5/14/2024 8:36:39 AM -05:005/14/2024 8:38:04 AM -05:00
5/14/2024 8:40:53 AM -05:005/14/2024 8:42:15 AM -05:00
5/14/2024 8:51:40 AM -05:005/14/2024 8:51:49 AM -05:00
5/14/2024 9:01:52 AM -05:005/14/2024 9:01:52 AM -05:00
5/14/2024 9:03:16 AM -05:005/14/2024 9:03:21 AM -05:00
5/14/2024 9:09:00 AM -05:005/14/2024 9:10:01 AM -05:00
5/14/2024 9:12:04 AM -05:005/14/2024 9:12:57 AM -05:00
5/14/2024 9:15:13 AM -05:005/14/2024 9:15:14 AM -05:00
5/14/2024 9:15:44 AM -05:005/14/2024 9:16:18 AM -05:00
5/14/2024 9:18:49 AM -05:005/14/2024 9:18:59 AM -05:00
5/14/2024 9:25:06 AM -05:005/14/2024 9:26:15 AM -05:00
5/14/2024 9:27:30 AM -05:005/14/2024 9:27:31 AM -05:00
5/14/2024 9:31:11 AM -05:005/14/2024 9:32:01 AM -05:00
5/14/2024 9:33:31 AM -05:005/14/2024 9:33:39 AM -05:00
5/14/2024 9:33:54 AM -05:005/14/2024 9:34:06 AM -05:00
5/14/2024 9:34:15 AM -05:005/14/2024 9:34:21 AM -05:00
5/14/2024 9:35:21 AM -05:005/14/2024 9:35:52 AM -05:00
5/14/2024 9:37:30 AM -05:005/14/2024 9:39:41 AM -05:00
5/14/2024 9:37:33 AM -05:005/14/2024 9:39:32 AM -05:00
5/14/2024 9:45:50 AM -05:005/14/2024 9:46:59 AM -05:00
5/14/2024 9:46:22 AM -05:005/14/2024 9:47:27 AM -05:00
5/14/2024 9:46:22 AM -05:005/14/2024 9:46:22 AM -05:00
5/14/2024 9:49:11 AM -05:005/14/2024 9:50:00 AM -05:00
5/14/2024 9:52:15 AM -05:005/14/2024 9:53:11 AM -05:00
5/14/2024 10:00:12 AM -05:005/14/2024 10:00:17 AM -05:00
5/14/2024 10:10:06 AM -05:005/14/2024 10:15:39 AM -05:00
5/14/2024 10:17:41 AM -05:005/14/2024 10:17:43 AM -05:00
5/14/2024 10:17:57 AM -05:005/14/2024 10:19:35 AM -05:00
5/14/2024 10:21:40 AM -05:005/14/2024 10:21:41 AM -05:00
5/14/2024 10:23:01 AM -05:005/14/2024 10:23:01 AM -05:00
5/14/2024 10:23:56 AM -05:005/14/2024 10:23:57 AM -05:00
5/14/2024 10:23:57 AM -05:005/14/2024 10:24:05 AM -05:00
5/14/2024 10:24:12 AM -05:005/14/2024 10:24:25 AM -05:00
5/14/2024 10:37:17 AM -05:005/14/2024 10:37:17 AM -05:00
5/14/2024 10:37:17 AM -05:005/14/2024 10:38:00 AM -05:00
5/14/2024 10:40:24 AM -05:005/14/2024 10:41:02 AM -05:00
5/14/2024 10:46:45 AM -05:005/14/2024 11:34:35 AM -05:00
5/14/2024 11:36:04 AM -05:005/14/2024 11:36:40 AM -05:00
5/14/2024 11:39:30 AM -05:005/14/2024 11:39:36 AM -05:00
5/14/2024 11:46:11 AM -05:005/14/2024 11:48:17 AM -05:00
5/14/2024 11:51:59 AM -05:005/14/2024 11:53:03 AM -05:00
5/14/2024 12:03:20 PM -05:005/14/2024 12:05:43 PM -05:00
5/14/2024 12:04:52 PM -05:005/14/2024 12:04:52 PM -05:00
5/14/2024 12:05:27 PM -05:005/14/2024 12:06:15 PM -05:00
5/14/2024 12:07:49 PM -05:005/14/2024 12:11:51 PM -05:00
5/14/2024 12:11:53 PM -05:005/14/2024 12:12:39 PM -05:00
5/14/2024 12:19:45 PM -05:005/14/2024 12:19:51 PM -05:00
5/14/2024 12:20:57 PM -05:005/14/2024 12:23:46 PM -05:00
5/14/2024 12:21:05 PM -05:005/14/2024 12:22:54 PM -05:00
5/14/2024 12:30:22 PM -05:005/14/2024 12:31:12 PM -05:00
5/14/2024 12:30:24 PM -05:005/14/2024 12:30:31 PM -05:00
5/14/2024 12:30:26 PM -05:005/14/2024 12:30:35 PM -05:00
5/14/2024 12:32:24 PM -05:005/14/2024 12:33:12 PM -05:00
5/14/2024 12:32:51 PM -05:005/14/2024 12:37:45 PM -05:00
5/14/2024 12:34:36 PM -05:005/14/2024 12:36:07 PM -05:00
5/14/2024 12:40:09 PM -05:005/14/2024 12:40:09 PM -05:00
5/14/2024 1:06:04 PM -05:005/14/2024 1:16:49 PM -05:00
5/14/2024 1:06:04 PM -05:005/14/2024 1:06:04 PM -05:00
5/14/2024 1:20:38 PM -05:005/14/2024 1:20:38 PM -05:00
5/14/2024 1:20:38 PM -05:005/14/2024 1:21:47 PM -05:00
5/14/2024 1:32:56 PM -05:005/14/2024 1:33:03 PM -05:00
5/14/2024 1:38:43 PM -05:005/14/2024 1:39:55 PM -05:00
5/14/2024 1:41:35 PM -05:005/14/2024 1:43:30 PM -05:00
5/14/2024 1:42:12 PM -05:005/14/2024 1:53:40 PM -05:00
5/14/2024 1:53:46 PM -05:005/14/2024 1:53:58 PM -05:00
5/14/2024 1:55:14 PM -05:005/14/2024 1:55:14 PM -05:00
5/14/2024 1:55:14 PM -05:005/14/2024 1:56:19 PM -05:00
5/14/2024 1:55:45 PM -05:005/14/2024 1:56:10 PM -05:00
5/14/2024 2:02:09 PM -05:005/14/2024 2:02:09 PM -05:00