Forum Discussion
Varan_15
3 years agoHelper III
Time Difference based by workstep wise
Hi All, I have data which is contains workstep (input, process, rejected, completed) i want to calculate the time differences between (first input entry time - last completed exit time ) Exa...
lin_k
3 years agoNew Member
Hi Varan_15
in this case you can follow the lined out steps:
1. Select Datatype as Date & Time (you can do this by right-clicking on the header of the column)
2. Add a custom row where you subtract Entry from Extract time, simply do this by using "-" and writing a formular
3. Format the result of your custom column as you need it
Let me know if this helps 🙂