AnsweredAssumed Answered

Timestamp to look as Time

Question asked by tays01s on Aug 21, 2017
Latest reply on Aug 21, 2017 by TomHays

I am using scripts to input:

Time start

Time stop

Time = (stop - start)/60, to convert to minutes. All this works fine.

However, users might sometimes want to make changes to records or make them retrospectively on a different date. To account for this I'd thought to change Time start/stop from Time to TimeStamp.


2 problems:

1. How can have the Start/Stop fields show only hh:mm (doing this via inspector doesn't work for TimeStamp) but be fully (ie. date and time) editable once the user enters the field? AND

2. I'd mistakenly thought TimeStamps could be subtracted from each other like time, but it appears not to be the case; solution?