Calculating Hours and minutes to Divide

[learner03]

I have a timestamp column and lines column. I need to calculate how much line been picked in the time duration.

For this I did following for calculating time difference-

DiffTime= var CurrentDate=MAX('Calender'[Date])

VAR MaxTime = CALCULATE(MAX('ULD History - Last 30 days'[Timestamp]), 'Calender'[Date] = CurrentDate)

VAR MinTime = CALCULATE(Min('ULD History - Last 30 days'[Timestamp]), 'Calender'[Date] = CurrentDate)

var Diff=DATEDIFF(MinTime, MaxTime, HOUR)

return

Diff

But, this only gives me first part of time, that is, 1

In actual, it is 1 hour 30 minutes.

If I am calculatingin minutes then it comes to 91 minutes and if I divide by 60 ( as  I hour has 60 minutes), then it gives me 1.51

How can I get to a stage where it divides by 1.30 as 90 minutes is 1 hour 30 minutes?

Timestamp	lines
30/11/2021 16:48	2
30/11/2021 16:48	2
30/11/2021 16:47	2
30/11/2021 16:44	3
30/11/2021 16:39	1
30/11/2021 16:39	1
30/11/2021 16:37	4
30/11/2021 16:37	1
30/11/2021 16:36	1
30/11/2021 16:34	1
30/11/2021 16:33	3
30/11/2021 16:33	2
30/11/2021 16:33	2
30/11/2021 16:28	2
30/11/2021 16:26	3
30/11/2021 16:25	1
30/11/2021 16:23	2
30/11/2021 16:22	2
30/11/2021 16:21	2
30/11/2021 16:19	1
30/11/2021 16:19	1
30/11/2021 16:17	4
30/11/2021 16:17	1
30/11/2021 16:17	1
30/11/2021 16:15	2
30/11/2021 16:12	2
30/11/2021 16:11	8
30/11/2021 16:10	1
30/11/2021 16:09	1
30/11/2021 16:09	1
30/11/2021 16:08	1
30/11/2021 16:08	2
30/11/2021 16:07	2
30/11/2021 15:57	1
30/11/2021 15:56	1
30/11/2021 15:56	1
30/11/2021 15:55	3
30/11/2021 15:53	2
30/11/2021 15:50	4
30/11/2021 15:49	2
30/11/2021 15:46	4
30/11/2021 15:45	2
30/11/2021 15:42	2
30/11/2021 15:40	4
30/11/2021 15:39	4
30/11/2021 15:39	1
30/11/2021 15:37	3
30/11/2021 15:35	8
30/11/2021 15:34	1
30/11/2021 15:33	2
30/11/2021 15:32	3
30/11/2021 15:32	-3
30/11/2021 15:31	3
30/11/2021 15:30	2
30/11/2021 15:30	1
30/11/2021 15:29	4
30/11/2021 15:29	1
30/11/2021 15:28	2
30/11/2021 15:27	-2
30/11/2021 15:24	2
30/11/2021 15:23	4
30/11/2021 15:17	2

[amitchandak]

@learner03 , Ideally diff include only one side. If it always +1 , then you can try like

var Diff=DATEDIFF(MinTime, MaxTime, HOUR) -1

or

check this to

var Diff= MaxTime - MinTime

This will directly give time