Forum Discussion

Smudgers9's avatar
Smudgers9
Frequent Visitor
2 years ago

Time difference between 2 dates not calculating when over 24hrs

I am trying to display the difference in time taken between 2 columns.   My data source is Excel.  Dates must be in UK format.   Column 1 - Date Logged (format Custom dd/mm/yyyy hh:mm) Column 2 -...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

Remember that datetimes are numbers too. The Integer part is the number of days since Dec 30 1899, and the fraction is the time part.  Simply subtract one date from the other, multiply by 24 to get the number of hours and then add the minutes and seconds via FORMAT.

Smudgers9's avatar
Smudgers9
Frequent Visitor
2 years ago

Hi lbendlin I'm not sure I follow.  I have done this but the results are a little strange as in the output should give me 53:19:00 but the number converted is 07:36:00.  Using Data Type - Time for the column.

 

ResolutionColumn = ('Table'[Date Resolved]-'Table'[Date Logged])*24