Forum Discussion

AnneTheisen's avatar
AnneTheisen
Qrew Trainee
11 years ago

concatenate a date and a time field to one date/time field

I have a start event and stop event that is recorded as separate date and time of day fields. I want to be able to calculate duration but need the date as some events start today but end tomorrow. ...
Forms
Formulas and functions
NotificationsEmail
DavidHawe's avatar
DavidHawe
Qrew Trainee
11 years ago
In your formula field for duration (this is untested) you should be able to use:

ToTimestamp([end date],[end time])-ToTimestamp([beginning date],[beginning time])