Difference in time spanning 2 days

[BA11501Banderso]

I have a column with "call received" that occurs near midnight 23:50 and an "on-site" column with a time of 0:24.  I'm trying to calculate the difference in minutes using a formula ("call received"-"on-site")*1440 but I'm getting a large negative number (-1,406).  How do I adjust the formula to cover responses that span two days?

Thank you!

[ValtteriN · Accepted solution]

Hi,

Try using DATEDIFF function. E.g. 

DATEDIFF('Table'[c1],'Table'[c2],MINUTE)


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[BA11501Banderso]

The problem is the way the info gets populated into the table the date is the same for everything, but the time of day is different so using the datediff gives me the same number I was getting before.

[v-easonf-msft]

Hi, @BA11501Banderso 

Can you share a sample data for further research?

Best Regards,
Community Support Team _ Eason