Solved: Difference in time spanning 2 days

BA11501Banderso · ‎02-23-2022

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 · ‎02-23-2022

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/

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

View solution in original post

ValtteriN · ‎02-23-2022

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/

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

BA11501Banderso · ‎02-23-2022

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.