This content has been marked as final. Show 6 replies
I have a field taken from a spreadsheet that has a timestamp however for few records it just has the time. How do I populate the missing date? WHen I calculate the interval I get the wrong figures as its subtracting time (epoch date I assume) from the timestamp.
eg: 11:30:00 - 23/10/2017 11:10:10
Your help is appreciated.