Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a CSV file with two timestamps in (see attached) and I'm trying to do the following at load:
I have tried lots of different ways but have been unsuccessful...and I suspect it's down to the format of the timestamp field in the CSV file
Ideas please
P.S the native table file has to be a CSV as it's an auto-output from the data source...and I cannot connect to the data source directly
Hi Conwayro,
After I open your csv, I saw that the timestamp1 and timestamp2 are totally same, so I think the comparison is 0 for these samples.
And for your questions, I think you can use below function to solve that:
1.=Interval( Timestamp1-Timestamp2, 'hh:mm' )
2.=Interval(Timestamp2 - now(), 'hh:mm' )
if not correct, please tell me what you want and it's better to give a sample.
Aiolos Zhao