Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
Want to calculate productive hours per user on the date selected from date slicer. Start time of user is the time from where it start to process his first activty and end time is the last processed activity of that user on that particular date and also exclude the 1 hour break from that time .
Documnt ID User Start Date2 End Date Start Time END Time
2000010681 | UCON900030 | 17 January 2023 | 18 January 2023 | 15:53:34 | 12:20:22 |
2000010681 | UCON900031 | 11 January 2023 | 12 January 2023 | 17:18:43 | 18:35:34 |
2000010681 | UCON900042 | 06 January 2023 | 09 January 2023 | 12:37:51 | 09:34:28 |
2000010681 | UCON900061 | 19 December 2022 | 19 December 2022 | 15:40:48 | 17:25:11 |
2000010681 | UCON900031 | 24 November 2022 | 19 December 2022 | 17:20:31 | 15:40:48 |
2000010681 | UCON900015 | 02 November 2022 | 02 November 2022 | 09:47:06 | 11:50:02 |
2000010681 | UCON900015 | 26 September 2022 | 02 November 2022 | 16:46:14 | 09:47:06 |
2000010681 | UCON900009 | 16 June 2022 | 17 June 2022 | 16:23:55 | 11:03:33 |
2000010681 | UCON900029 | 25 April 2022 | 26 April 2022 | 15:21:11 | 11:35:46 |
2000010681 | UCON900003 | 22 April 2022 | 22 April 2022 | 18:09:43 | 18:17:51 |
2000011084 | UCON900061 | 19 December 2022 | 19 December 2022 | 15:46:58 | 17:48:02 |
2000011084 | UCON900031 | 21 November 2022 | 19 December 2022 | 13:03:57 | 15:46:58 |
2000011084 | UCON900046 | 17 November 2022 | 18 November 2022 | 14:49:47 | 10:27:03 |
2000011084 | UCON900022 | 08 September 2022 | 09 September 2022 | 17:33:56 | 13:39:57 |
2000011084 | UCON900024 | 02 May 2022 | 04 May 2022 | 13:42:24 | 15:07:34 |
2000011084 | UCON900030 | 29 April 2022 | 02 May 2022 | 19:45:52 | 09:26:31 |
2000011084 | UCON900023 | 25 April 2022 | 26 April 2022 | 16:33:01 | 10:12:06 |
2000016604 | UCON900005 | 13 May 2022 | 14 May 2022 | 13:21:48 | 10:26:06 |
2000019219 | UCON900029 | 25 May 2022 | 25 May 2022 | 10:05:52 | 10:16:27 |
2000019219 | UCON900029 | 23 May 2022 | 25 May 2022 | 17:21:49 | 10:05:52 |
2000019219 | UCON900007 | 23 May 2022 | 23 May 2022 | 16:43:20 | 17:20:57 |
2000021386 | UCON900031 | 21 December 2022 | 21 December 2022 | 08:25:26 | 09:55:22 |
2000021386 | UCON900061 | 21 December 2022 | 21 December 2022 | 09:55:22 | 10:02:09 |
2000021386 | UCON900061 | 21 December 2022 | 21 December 2022 | 10:02:12 | 10:07:32 |
2000021386 | UCON900015 | 15 July 2022 | 15 July 2022 | 09:47:25 | 11:38:54 |
2000021386 | UCON900015 | 01 July 2022 | 02 July 2022 | 15:08:17 | 16:25:49 |
2000021386 | UCON900014 | 27 June 2022 | 27 June 2022 | 10:37:43 | 10:38:16 |
2000021386 | UCON900014 | 01 June 2022 | 27 June 2022 | 08:00:48 | 10:37:39 |
2000021386 | UCON900008 | 30 May 2022 | 31 May 2022 | 15:00:22 | 17:23:20 |
2000023187 | UCON900015 | 01 July 2022 | 02 July 2022 | 17:41:48 | 17:03:05 |
2000023187 | UCON900029 | 22 June 2022 | 23 June 2022 | 10:42:55 | 19:43:01 |
2000023187 | UCON900019 | 20 June 2022 | 22 June 2022 | 12:37:42 | 10:42:54 |
2000023187 | UCON900011 | 16 June 2022 | 17 June 2022 | 16:01:56 | 18:47:49 |
2000023187 | UCON900016 | 15 June 2022 | 15 June 2022 | 17:14:02 | 17:24:36 |
2000023187 | UCON900016 | 13 June 2022 | 15 June 2022 | 15:58:12 | 17:14:02 |
2000023187 | UCON900013 | 10 June 2022 | 13 June 2022 | 11:12:14 | 15:58:11 |
2000023187 | UCON900015 | 10 June 2022 | 10 June 2022 | 09:40:42 | 09:41:49 |
2000023187 | UCON900015 | 08 June 2022 | 10 June 2022 | 08:09:26 | 09:40:42 |
2000023187 | UCON900029 | 07 June 2022 | 07 June 2022 | 19:14:25 | 19:17:16 |
2000023187 | UCON900029 | 07 June 2022 | 07 June 2022 | 19:17:16 | 19:17:48 |
2000023187 | UCON900029 | 07 June 2022 | 07 June 2022 | 19:17:48 | 19:19:20 |
2000023187 | UCON900029 | 03 June 2022 | 07 June 2022 | 10:19:41 | 19:14:25 |
2000023187 | UCON900003 | 02 June 2022 | 03 June 2022 | 17:41:53 | 10:16:41 |
2000023201 | UCON900006 | 30 January 2023 | 31 January 2023 | 16:48:55 | 16:00:23 |
2000023201 | UCON900031 | 10 January 2023 | 10 January 2023 | 11:58:20 | 16:01:25 |
2000023201 | UCON900061 | 10 January 2023 | 10 January 2023 | 16:01:25 | 16:03:43 |
2000023201 | UCON900061 | 09 January 2023 | 10 January 2023 | 16:52:41 | 11:58:16 |
2000023201 | UCON900007 | 26 September 2022 | 26 September 2022 | 12:18:21 | 17:38:46 |
2000023201 | UCON900007 | 26 September 2022 | 26 September 2022 | 17:38:49 | 17:42:05 |
2000023201 | UCON900041 | 20 September 2022 | 21 September 2022 | 11:51:38 | 15:52:08 |
2000023201 | UCON900048 | 06 September 2022 | 08 September 2022 | 12:22:42 | 09:51:35 |
2000023201 | UCON900015 | 03 June 2022 | 06 June 2022 | 10:33:39 | 18:05:11 |
2000023201 | UCON900007 | 02 June 2022 | 03 June 2022 | 17:41:56 | 10:31:03 |
2000023206 | UCON900014 | 05 September 2022 | 07 September 2022 | 13:22:36 | 15:11:08 |
2000023206 | UCON900007 | 02 September 2022 | 05 September 2022 | 15:41:11 | 13:22:32 |
2000023206 | UCON900015 | 03 June 2022 | 06 June 2022 | 13:32:01 | 15:50:47 |
2000023206 | UCON900003 | 02 June 2022 | 03 June 2022 | 17:41:57 | 10:38:06 |
2000023216 | UCON900009 | 30 August 2022 | 27 September 2022 | 15:20:53 | 16:19:01 |
2000023216 | UCON900015 | 01 July 2022 | 02 July 2022 | 17:37:33 | 17:04:33 |
2000023216 | UCON900009 | 29 June 2022 | 30 June 2022 | 12:42:25 | 16:46:14 |
2000023216 | UCON900011 | 28 June 2022 | 28 June 2022 | 15:41:57 | 15:43:55 |
2000023216 | UCON900011 | 27 June 2022 | 28 June 2022 | 11:02:32 | 15:41:57 |
2000023216 | UCON900029 | 21 June 2022 | 23 June 2022 | 15:46:55 | 19:39:00 |
2000023216 | UCON900011 | 20 June 2022 | 20 June 2022 | 08:20:37 | 10:32:32 |
2000023216 | UCON900013 | 17 June 2022 | 17 June 2022 | 15:59:21 | 16:02:37 |
2000023216 | UCON900013 | 16 June 2022 | 17 June 2022 | 16:18:36 | 15:59:20 |
2000023216 | UCON900011 | 10 June 2022 | 10 June 2022 | 11:02:50 | 11:06:01 |
2000023216 | UCON900011 | 08 June 2022 | 10 June 2022 | 15:57:47 | 11:02:50 |
2000023216 | UCON900016 | 03 June 2022 | 08 June 2022 | 10:52:35 | 15:55:12 |
2000023216 | UCON900003 | 02 June 2022 | 03 June 2022 | 18:25:43 | 10:50:53 |
2000025520 | UCON900032 | 20 January 2023 | 20 January 2023 | 09:12:01 | 17:46:11 |
2000025520 | UCON900009 | 13 June 2022 | 14 June 2022 | 12:43:02 | 12:50:54 |
2000025520 | UCON900011 | 09 June 2022 | 10 June 2022 | 09:54:01 | 13:14:52 |
2000025520 | UCON900009 | 07 June 2022 | 08 June 2022 | 16:53:15 | 17:02:04 |
2000025520 | UCON900007 | 06 June 2022 | 07 June 2022 | 19:36:04 | 16:17:32 |
2000027090 | UCON900045 | 23 December 2022 | 26 December 2022 | 15:38:56 | 11:47:41 |
2000027090 | UCON900031 | 14 September 2022 | 15 September 2022 | 15:49:25 | 11:25:04 |
2000027090 | UCON900009 | 10 June 2022 | 13 June 2022 | 14:54:02 | 11:56:32 |
2000027090 | UCON900003 | 09 June 2022 | 10 June 2022 | 18:46:54 | 14:52:33 |
2000027437 | UCON900045 | 28 November 2022 | 28 November 2022 | 15:29:51 | 16:11:14 |
2000027437 | UCON900045 | 25 November 2022 | 28 November 2022 | 10:38:40 | 15:29:49 |
2000027437 | UCON900003 | 10 June 2022 | 13 June 2022 | 18:24:02 | 10:44:07 |
2000029655 | UCON900062 | 03 February 2023 | 03 February 2023 | 11:02:53 | 17:46:32 |
2000029655 | UCON900061 | 19 December 2022 | 19 December 2022 | 15:42:58 | 17:44:43 |
2000029655 | UCON900031 | 04 November 2022 | 19 December 2022 | 12:27:32 | 15:42:58 |
2000029655 | UCON900015 | 03 November 2022 | 03 November 2022 | 14:59:00 | 17:47:34 |
2000029655 | UCON900030 | 22 July 2022 | 22 July 2022 | 10:53:25 | 10:57:37 |
2000029655 | UCON900030 | 22 July 2022 | 22 July 2022 | 10:57:38 | 11:00:04 |
2000029655 | UCON900030 | 16 June 2022 | 22 July 2022 | 16:49:30 | 10:53:25 |
2000029655 | UCON900024 | 16 June 2022 | 16 June 2022 | 16:24:07 | 16:46:32 |
2000030252 | UCON900011 | 20 June 2022 | 21 June 2022 | 08:00:14 | 18:29:56 |
2000030252 | UCON900003 | 17 June 2022 | 17 June 2022 | 15:43:10 | 18:01:20 |
2000030252 | UCON900011 | 17 June 2022 | 17 June 2022 | 18:15:14 | 18:23:09 |
2000031200 | UCON900045 | 28 November 2022 | 28 November 2022 | 15:05:54 | 15:17:47 |
2000031200 | UCON900045 | 25 November 2022 | 28 November 2022 | 10:13:27 | 15:05:51 |
2000031200 | UCON900036 | 21 November 2022 | 23 November 2022 | 15:23:37 | 10:45:55 |
2000031200 | UCON900011 | 12 September 2022 | 13 September 2022 | 11:11:35 | 15:09:17 |
2000031200 | UCON900011 | 03 August 2022 | 03 August 2022 | 14:07:21 | 14:08:27 |
2000031200 | UCON900011 | 02 August 2022 | 03 August 2022 | 09:25:12 | 14:07:17 |
2000031200 | UCON900011 | 01 August 2022 | 02 August 2022 | 11:39:53 | 09:25:08 |
2000031200 | UCON900009 | 21 June 2022 | 23 June 2022 | 17:20:19 | 17:19:34 |
2000031200 | UCON900005 | 20 June 2022 | 21 June 2022 | 18:21:07 | 10:13:47 |
2000031219 | UCON900013 | 26 July 2022 | 26 July 2022 | 16:35:32 | 16:39:51 |
2000031219 | UCON900013 | 25 July 2022 | 26 July 2022 | 14:31:02 | 16:35:29 |
2000031219 | UCON900015 | 22 June 2022 | 23 June 2022 | 19:02:47 | 14:34:59 |
2000031219 | UCON900019 | 21 June 2022 | 22 June 2022 | 16:56:30 | 19:02:45 |
2000031219 | UCON900024 | 20 June 2022 | 21 June 2022 | 18:21:11 | 10:25:53 |
2000031609 | UCON900009 | 06 September 2022 | 07 September 2022 | 09:36:37 | 10:15:01 |
2000031609 | UCON900018 | 20 June 2022 | 21 June 2022 | 18:51:27 | 14:56:00 |
2000032194 | UCON900018 | 21 June 2022 | 22 June 2022 | 16:28:18 | 12:41:17 |
2000035147 | UCON900007 | 26 December 2022 | 26 December 2022 | 09:32:32 | 18:26:53 |
2000035147 | UCON900031 | 02 September 2022 | 26 December 2022 | 16:07:23 | 09:32:32 |
2000035147 | UCON900007 | 27 June 2022 | 28 June 2022 | 16:37:15 | 10:54:53 |
2000035510 | UCON900061 | 19 December 2022 | 19 December 2022 | 15:42:41 | 17:27:00 |
2000035510 | UCON900031 | 28 June 2022 | 19 December 2022 | 16:12:59 | 15:42:41 |
2000035510 | UCON900004 | 27 June 2022 | 28 June 2022 | 19:06:52 | 16:12:51 |
2000036547 | UCON900029 | 14 July 2022 | 12 August 2022 | 17:16:32 | 13:10:45 |
2000036547 | UCON900013 | 05 July 2022 | 06 July 2022 | 14:23:51 | 14:36:39 |
2000036547 | UCON900009 | 01 July 2022 | 04 July 2022 | 12:12:51 | 16:34:26 |
2000036547 | UCON900004 | 30 June 2022 | 30 June 2022 | 16:26:37 | 16:52:26 |
2000036590 | UCON900009 | 01 July 2022 | 01 July 2022 | 13:31:48 | 15:33:15 |
2000036590 | UCON900009 | 01 July 2022 | 01 July 2022 | 15:33:15 | 15:37:23 |
2000036590 | UCON900024 | 30 June 2022 | 30 June 2022 | 16:51:02 | 17:24:03 |
2000037711 | UCON900042 | 01 December 2022 | 02 December 2022 | 12:08:12 | 10:50:16 |
2000037711 | UCON900030 | 03 November 2022 | 04 November 2022 | 17:38:56 | 13:06:12 |
2000037711 | UCON900015 | 06 July 2022 | 06 July 2022 | 08:03:48 | 18:14:58 |
2000037711 | UCON900022 | 05 July 2022 | 05 July 2022 | 14:21:54 | 14:22:23 |
2000037711 | UCON900022 | 04 July 2022 | 05 July 2022 | 18:09:46 | 14:21:54 |
2000037711 | UCON900005 | 01 July 2022 | 04 July 2022 | 19:03:53 | 18:07:43 |
2000037863 | UCON900048 | 31 January 2023 | 01 February 2023 | 17:10:25 | 18:01:21 |
2000037863 | UCON900008 | 05 July 2022 | 05 July 2022 | 09:48:30 | 09:57:10 |
2000037863 | UCON900024 | 04 July 2022 | 05 July 2022 | 11:56:08 | 09:48:30 |
Can any one help me to get the start time and end time of each user on a particular date selected from date slicer.
Hi All,
Can any one help me to get the start time and end time of each user on a particular date selected from date slicer.
Hi All,
Can any one help me to get the start time and end time of each user on a particular date selected from date slicer.
I want to get the productive hours. Seems good
Can you please suggest
Can you please suggest solutions of it
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |