Hi all,
I’m having an issue converting a time measurement into seconds, hours etc.
The field total_time appears to load in a string format, e.g. 00162597 corresponds to 00 hours:16 minutes:25 seconds.97milliseconds.
I have tried the following expression =Interval(Time#(total_time,'hh:mm:ss.ff'),'ss') to convert it to seconds, but it’s returning a null value.
What’s I find strange is that if I enter =Interval(Time#(00:16:25.77,'hh:mm:ss.ff'),'ss') it will return the correct value, 985.97 seconds.
Is there an issue with how it’s reading the field? Should I have it time-stamped in the load string in a certain way initially?
Thanks for any help.
