I have 2 fields, a start time and an end time and I want to work out the time taken, however the two fields are in different formats:
Start Time
End Time
Duration (Required)
13:45:22
140024
00:15:02
The field start time is formatted as hh:mm:ss however the end time is just a number, I believe I need to either convert the start time to a number or the end time to hh:mm:ss to then work out the duration.
