Forum Discussion
Solved
Calculate difference between two times? In HH:MM:SS
Hi all, How do I calculate the difference between two time columns? Both columns are in HH:MM:SS and I would like the difference column to be the same. thanks,
Hi HenryJS,
Perhaps you can try to convert your time value to total second(numeric) then you can simply use math operator to calculate on converted values.
For duration and time value transform, you can take a look at the following blog:
Regards,
Xiaoxin Sheng
Hi HenryJS,
Perhaps you can try to convert your time value to total second(numeric) then you can simply use math operator to calculate on converted values.
For duration and time value transform, you can take a look at the following blog:
Regards,
Xiaoxin Sheng