Sum of totals, date diff

[shakkedgo]

hey all,

I have recods with ID ,line and Area 

each ID has multiple lines and each of those has start date and end date (see table)

ID	LINE	Area	start date	end date
111	1	A	1/1/22 13:40:01	1/1/22 13:40:03
111	2	A	1/1/22 13:40:01	1/1/22 13:50:03
111	3	A	1/1/22 13:38:01	1/1/22 20:38:01
222	1	A	2/2/22 10:40:10	2/2/22 10:50:02
222	2	A	2/2/22 10:40:06	2/2/22 11:40:10
333	1	B	1/1/22 13:40:01	1/1/22 16:40:01

I wnat to create a table to see the max time between each ID and then sum the the max by Area

the result sould look like this

the max beetween orders:

ID	Area	time
111	A	7
222	A	1
333	B	3

and then:

Area	total Hours
A	8
B	3

thanks

[shakkedgo]

thanks 
it works 

[amitchandak · Accepted solution]

@shakkedgo , Try like

Sumx(summarize(Table, Table[ID], Table[Area]), calculate(Maxx(Table, datediff(Table[start Date], Table[End Date], hour) )))