Forum Discussion
Solved
Calculating time between 2 different columns
Hello, I am sure this question has been asked million of times but I can't seem to find the solution and to be honest it is driving me insane. I have two columns with time stamps in a Appended Data...
Have you tried taking a simple difference and setting the column type to Time?
'Appended Data'[Next Start Time] - Appended Data'[INVOICE CREATED]Note: If processing time can be longer than 24 hours, this might not be a good approach.
Have you tried taking a simple difference and setting the column type to Time?
'Appended Data'[Next Start Time] - Appended Data'[INVOICE CREATED]Note: If processing time can be longer than 24 hours, this might not be a good approach.
OMG!!😯
Thats done it... I have a tendency to over think things😶
Just out of interest... is there a better approach than doing it this way as I will have thousands of lines to add to this append. Should I be doing it in power query instead as a calculated column on the report
Power Query would indeed be a better practice.
Try using Duration.From([Next Start Time] - [INVOICE CREATED]).