Forum Discussion
Finding a difference between 2 columns
Good morning, I have a table with a column titled Status Audit Type. Two of the values in this column are Create and Done and each has a corresponding date/time in another column Titled Status Ch...
I found the error so that isn't an issue. The formula returns a date and time. What I need is for it to return HH:MM
amitchandak I was able to get this to show a time but they aren't correct. I have a Create date/time of 4/19/2022 8:20:09 and a Done date/time of 10/31/22 6:17:17 that doesn't even show in the Matrix. Some with similar dates/times showing in the Matrix as 7 hours. Any other suggestions?