HELP CALCULATE OVERTIME

[Anonymous]

Guys, good afternoon!

I have a doubt when calculating overtime, I have this table below:

User Name	Project Name	Interval Start	Interval End
User01	Research and Development	11/04/2022 08:00	11/04/2022 12:07
User01	Research and Development	11/04/2022 13:10	11/04/2022 17:06
User01	Research and Development	12/04/2022 07:28	12/04/2022 12:01
User01	Research and Development	12/04/2022 13:00	12/04/2022 20:31
User01	Research and Development	13/04/2022 07:51	13/04/2022 12:01
User01	DevOps	13/04/2022 12:53	13/04/2022 14:19
User01	Research and Development	13/04/2022 14:19	13/04/2022 19:59
User02	On-Line Schedule	11/04/2022 08:00	11/04/2022 12:00
User02	On-Line Schedule	11/04/2022 13:00	11/04/2022 18:00
User02	On-Line Schedule	12/04/2022 08:00	12/04/2022 12:00
User02	Labs	12/04/2022 12:59	12/04/2022 17:20
User02	On-Line Schedule	13/04/2022 08:00	13/04/2022 12:00
User02	On-Line Schedule	13/04/2022 13:00	13/04/2022 13:30
User02	Labs	13/04/2022 13:30	13/04/2022 13:45
User02	On-Line Schedule	13/04/2022 13:45	13/04/2022 17:40

Where I have several hours of entry and exit on the same day.
And the workload is 8 hours, if it exceeds these 8 hours of work, it is already extra.
I'm racking my brains because I can't reduce the 8 hours of work from the total amount of hours, to leave only the overtime hours of the month.

Has anyone done this before and could help me out?

Thanks

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

If you want to get total minutes for each progress, please try 

Duration.TotalMinutes()

And according to this: but i want after the duration, to separate the amount of overtime from the total amount. 

If you want to know how many projects are overtime, please firstly add the Date column in Power Query

DateTime.Date([Interval Start])

Then try:

Amount of overtime = 
var _t=SUMMARIZE('Table',[User Name],[Project Name],[Date],"Minutes",SUM('Table'[Minutes]))
return COUNTROWS(FILTER(_t,[Minutes]>8*60))

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

speedramps,

Thanks for the feedback,

I've done that, but i want after the duration, to separate the amount of overtime from the total amount.

[speedramps]

e cam you bettre explain the problem.

Perhaps with a example if the desired output foe the example input date.

Try use the Duraction command , for example ...

Duration.Minutes([Interval End] - [Interval Start])