That is correct, I believe it is 11:59:47 Shin, I tried your approach and it indicated that dateparse is an unknown function?
Jim, your technique does not work as there is no date in this field just the timestamp, when I do so it simply adds Jan 1900 and doesn't indicate the times correctly.
The end result I am trying to achieve is to have all the times in a row so that I may group them into half hour periods during the work day (7am-930pm).
2 of 2 people found this helpful
Some data source does not allow dateparse.
[Time Conversion 2]
*** #2001/1/1# any date works if you only need time. ***
Rest of the steps are same.
Appreciate the shout out.