I have 2 columns in the format h:m:s. I want to subtract one from the other to get the time differences (typically in minutes and seconds).
When I subtract one from the other using the columns I get a time result
(:goTime - :waitTime);
ex: 10:20:18 - 10:16:15 = 12:04:03 AM
If I try to subtract the numeric portions I get "." results
0+ 3600*( Substr( :goTime, 1, 2 ) - Substr( :waitTime, 1, 2 ))
+ 60*( Substr( :goTime, 4, 2 )- Substr( :waitTime, 4, 2 ))
+(Substr( :goTime, 7, 2 ) - Substr( :waitTime, 7, 2 ));
On the time portion, is there a format change I can use to get just the elapsed time? I am sure this is simple but I am just not seeing it. Thanks for any help.
@KST-CPT,
You can use the Date Difference function irrespective of whether you want to calculate the difference in minutes/seconds or a different interval. Please see below an example :
The column formula that I used is provided below:
