Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
KuntalSingh
Helper III
Helper III

Need to calculated productive hours

‎02-24-2023 01:37 AM

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

2000010681UCON90003017 January 202318 January 202315:53:3412:20:22
2000010681UCON90003111 January 202312 January 202317:18:4318:35:34
2000010681UCON90004206 January 202309 January 202312:37:5109:34:28
2000010681UCON90006119 December 202219 December 202215:40:4817:25:11
2000010681UCON90003124 November 202219 December 202217:20:3115:40:48
2000010681UCON90001502 November 202202 November 202209:47:0611:50:02
2000010681UCON90001526 September 202202 November 202216:46:1409:47:06
2000010681UCON90000916 June 202217 June 202216:23:5511:03:33
2000010681UCON90002925 April 202226 April 202215:21:1111:35:46
2000010681UCON90000322 April 202222 April 202218:09:4318:17:51
2000011084UCON90006119 December 202219 December 202215:46:5817:48:02
2000011084UCON90003121 November 202219 December 202213:03:5715:46:58
2000011084UCON90004617 November 202218 November 202214:49:4710:27:03
2000011084UCON90002208 September 202209 September 202217:33:5613:39:57
2000011084UCON90002402 May 202204 May 202213:42:2415:07:34
2000011084UCON90003029 April 202202 May 202219:45:5209:26:31
2000011084UCON90002325 April 202226 April 202216:33:0110:12:06
2000016604UCON90000513 May 202214 May 202213:21:4810:26:06
2000019219UCON90002925 May 202225 May 202210:05:5210:16:27
2000019219UCON90002923 May 202225 May 202217:21:4910:05:52
2000019219UCON90000723 May 202223 May 202216:43:2017:20:57
2000021386UCON90003121 December 202221 December 202208:25:2609:55:22
2000021386UCON90006121 December 202221 December 202209:55:2210:02:09
2000021386UCON90006121 December 202221 December 202210:02:1210:07:32
2000021386UCON90001515 July 202215 July 202209:47:2511:38:54
2000021386UCON90001501 July 202202 July 202215:08:1716:25:49
2000021386UCON90001427 June 202227 June 202210:37:4310:38:16
2000021386UCON90001401 June 202227 June 202208:00:4810:37:39
2000021386UCON90000830 May 202231 May 202215:00:2217:23:20
2000023187UCON90001501 July 202202 July 202217:41:4817:03:05
2000023187UCON90002922 June 202223 June 202210:42:5519:43:01
2000023187UCON90001920 June 202222 June 202212:37:4210:42:54
2000023187UCON90001116 June 202217 June 202216:01:5618:47:49
2000023187UCON90001615 June 202215 June 202217:14:0217:24:36
2000023187UCON90001613 June 202215 June 202215:58:1217:14:02
2000023187UCON90001310 June 202213 June 202211:12:1415:58:11
2000023187UCON90001510 June 202210 June 202209:40:4209:41:49
2000023187UCON90001508 June 202210 June 202208:09:2609:40:42
2000023187UCON90002907 June 202207 June 202219:14:2519:17:16
2000023187UCON90002907 June 202207 June 202219:17:1619:17:48
2000023187UCON90002907 June 202207 June 202219:17:4819:19:20
2000023187UCON90002903 June 202207 June 202210:19:4119:14:25
2000023187UCON90000302 June 202203 June 202217:41:5310:16:41
2000023201UCON90000630 January 202331 January 202316:48:5516:00:23
2000023201UCON90003110 January 202310 January 202311:58:2016:01:25
2000023201UCON90006110 January 202310 January 202316:01:2516:03:43
2000023201UCON90006109 January 202310 January 202316:52:4111:58:16
2000023201UCON90000726 September 202226 September 202212:18:2117:38:46
2000023201UCON90000726 September 202226 September 202217:38:4917:42:05
2000023201UCON90004120 September 202221 September 202211:51:3815:52:08
2000023201UCON90004806 September 202208 September 202212:22:4209:51:35
2000023201UCON90001503 June 202206 June 202210:33:3918:05:11
2000023201UCON90000702 June 202203 June 202217:41:5610:31:03
2000023206UCON90001405 September 202207 September 202213:22:3615:11:08
2000023206UCON90000702 September 202205 September 202215:41:1113:22:32
2000023206UCON90001503 June 202206 June 202213:32:0115:50:47
2000023206UCON90000302 June 202203 June 202217:41:5710:38:06
2000023216UCON90000930 August 202227 September 202215:20:5316:19:01
2000023216UCON90001501 July 202202 July 202217:37:3317:04:33
2000023216UCON90000929 June 202230 June 202212:42:2516:46:14
2000023216UCON90001128 June 202228 June 202215:41:5715:43:55
2000023216UCON90001127 June 202228 June 202211:02:3215:41:57
2000023216UCON90002921 June 202223 June 202215:46:5519:39:00
2000023216UCON90001120 June 202220 June 202208:20:3710:32:32
2000023216UCON90001317 June 202217 June 202215:59:2116:02:37
2000023216UCON90001316 June 202217 June 202216:18:3615:59:20
2000023216UCON90001110 June 202210 June 202211:02:5011:06:01
2000023216UCON90001108 June 202210 June 202215:57:4711:02:50
2000023216UCON90001603 June 202208 June 202210:52:3515:55:12
2000023216UCON90000302 June 202203 June 202218:25:4310:50:53
2000025520UCON90003220 January 202320 January 202309:12:0117:46:11
2000025520UCON90000913 June 202214 June 202212:43:0212:50:54
2000025520UCON90001109 June 202210 June 202209:54:0113:14:52
2000025520UCON90000907 June 202208 June 202216:53:1517:02:04
2000025520UCON90000706 June 202207 June 202219:36:0416:17:32
2000027090UCON90004523 December 202226 December 202215:38:5611:47:41
2000027090UCON90003114 September 202215 September 202215:49:2511:25:04
2000027090UCON90000910 June 202213 June 202214:54:0211:56:32
2000027090UCON90000309 June 202210 June 202218:46:5414:52:33
2000027437UCON90004528 November 202228 November 202215:29:5116:11:14
2000027437UCON90004525 November 202228 November 202210:38:4015:29:49
2000027437UCON90000310 June 202213 June 202218:24:0210:44:07
2000029655UCON90006203 February 202303 February 202311:02:5317:46:32
2000029655UCON90006119 December 202219 December 202215:42:5817:44:43
2000029655UCON90003104 November 202219 December 202212:27:3215:42:58
2000029655UCON90001503 November 202203 November 202214:59:0017:47:34
2000029655UCON90003022 July 202222 July 202210:53:2510:57:37
2000029655UCON90003022 July 202222 July 202210:57:3811:00:04
2000029655UCON90003016 June 202222 July 202216:49:3010:53:25
2000029655UCON90002416 June 202216 June 202216:24:0716:46:32
2000030252UCON90001120 June 202221 June 202208:00:1418:29:56
2000030252UCON90000317 June 202217 June 202215:43:1018:01:20
2000030252UCON90001117 June 202217 June 202218:15:1418:23:09
2000031200UCON90004528 November 202228 November 202215:05:5415:17:47
2000031200UCON90004525 November 202228 November 202210:13:2715:05:51
2000031200UCON90003621 November 202223 November 202215:23:3710:45:55
2000031200UCON90001112 September 202213 September 202211:11:3515:09:17
2000031200UCON90001103 August 202203 August 202214:07:2114:08:27
2000031200UCON90001102 August 202203 August 202209:25:1214:07:17
2000031200UCON90001101 August 202202 August 202211:39:5309:25:08
2000031200UCON90000921 June 202223 June 202217:20:1917:19:34
2000031200UCON90000520 June 202221 June 202218:21:0710:13:47
2000031219UCON90001326 July 202226 July 202216:35:3216:39:51
2000031219UCON90001325 July 202226 July 202214:31:0216:35:29
2000031219UCON90001522 June 202223 June 202219:02:4714:34:59
2000031219UCON90001921 June 202222 June 202216:56:3019:02:45
2000031219UCON90002420 June 202221 June 202218:21:1110:25:53
2000031609UCON90000906 September 202207 September 202209:36:3710:15:01
2000031609UCON90001820 June 202221 June 202218:51:2714:56:00
2000032194UCON90001821 June 202222 June 202216:28:1812:41:17
2000035147UCON90000726 December 202226 December 202209:32:3218:26:53
2000035147UCON90003102 September 202226 December 202216:07:2309:32:32
2000035147UCON90000727 June 202228 June 202216:37:1510:54:53
2000035510UCON90006119 December 202219 December 202215:42:4117:27:00
2000035510UCON90003128 June 202219 December 202216:12:5915:42:41
2000035510UCON90000427 June 202228 June 202219:06:5216:12:51
2000036547UCON90002914 July 202212 August 202217:16:3213:10:45
2000036547UCON90001305 July 202206 July 202214:23:5114:36:39
2000036547UCON90000901 July 202204 July 202212:12:5116:34:26
2000036547UCON90000430 June 202230 June 202216:26:3716:52:26
2000036590UCON90000901 July 202201 July 202213:31:4815:33:15
2000036590UCON90000901 July 202201 July 202215:33:1515:37:23
2000036590UCON90002430 June 202230 June 202216:51:0217:24:03
2000037711UCON90004201 December 202202 December 202212:08:1210:50:16
2000037711UCON90003003 November 202204 November 202217:38:5613:06:12
2000037711UCON90001506 July 202206 July 202208:03:4818:14:58
2000037711UCON90002205 July 202205 July 202214:21:5414:22:23
2000037711UCON90002204 July 202205 July 202218:09:4614:21:54
2000037711UCON90000501 July 202204 July 202219:03:5318:07:43
2000037863UCON90004831 January 202301 February 202317:10:2518:01:21
2000037863UCON90000805 July 202205 July 202209:48:3009:57:10
2000037863UCON90002404 July 202205 July 202211:56:0809:48:30
Labels:
Message 1 of 8
627 Views
0
7 REPLIES 7
KuntalSingh
Helper III
Helper III

‎02-28-2023 04:21 AM

Can any one help me to get the start time and end time of each user on a particular date selected from date slicer.

Message 8 of 8
489 Views
0
KuntalSingh
Helper III
Helper III

‎02-28-2023 01:05 AM

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.

Message 7 of 8
505 Views
0
KuntalSingh
Helper III
Helper III

‎02-27-2023 10:43 PM

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.

Message 6 of 8
516 Views
0
rajulshah
Super User
Super User

‎02-24-2023 02:24 AM

@KuntalSingh 

 

Is this what you need? Please confirm.

rajulshah_0-1677234277755.png

 

Message 2 of 8
586 Views
0
KuntalSingh
Helper III
Helper III
In response to rajulshah

‎02-26-2023 11:44 PM

I want to get the productive hours. Seems good 

Can you please suggest

Message 3 of 8
541 Views
0
KuntalSingh
Helper III
Helper III
In response to KuntalSingh

‎02-27-2023 03:33 AM

Can you please suggest solutions of it

Message 4 of 8
531 Views
0
rajulshah
Super User
Super User
In response to KuntalSingh

‎02-28-2023 04:13 AM

@KuntalSingh , When you say it seems good, do you want the exact values?

Message 5 of 8
494 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All