Convert timespan d:hh:mm:ss to number
Hi,
I have a field that is imported from Siebel to CSV in the format d:hh:mm:ss.
I need to convert this back to seconds. I have tried changing the format of
the cells but this does not work.
Can anyone help?
Thanks
|