And what would this calculation calculate? How does it need to work for you?
Hi Phil, I would like it to calculate Departure_time - 2hrs so that travellers know what time they need to check in before their flight. The result should be shown in time format. Thanks for your help, Leigh
So if you enter departure time into a Time field, this calculation field will compute a time two hours previous:
DepartureTime - 2 * 3600
There are 3600 seconds to an hour and both time and time stamp fields record their values as an integer representing seconds. A time field records the number of seconds since midnight. A TimeStamp field records the number of seconds since Midnight of 12/31/0000.
If there is any chance that you will need to compute a time just prior to midnight, I suggest using TimeStamp fields instead of time.
Thank you Phil that's really helpful!