SPOTFIRE: Is there a time function that can be used from a custom expression to convert the milliseconds value in the START_TIME and END_TIME of the Schedules to a user friendly time of day

[Steve Rose 2]

example

 

START_TIME Time of Day

23400000 6:30 AM

[Nawaz Ali Mohammad]

You need to create calculated column as below:

 

CONCATENATE(String(INTEGER([start_time]/1000)/86400,"hh:mm:ss"),".",[start_time]-(INTEGER([start_time]/1000)*1000))