Calendar Function Date & Time

Hello

I use the the calendar function for bookings so a Start Date & Time and an End Date and Time as one field. Is there a way of working out the duration of the booking in a separate field? A bit stuck!

That is an issue that to my knowledge has never been fixed.

The best I could do was extract the start time and end time as 2 texts, then create 2 variables from those, then do over-complicated calculations with those variables to find the duration. Sadly I doubt there is a better method out there.

1 Like

If you’re referring to the Timer data type, I agree! There needs to be a BUILT-IN library of developer-accessible functions for manipulating that beast, including some display formatting options. I’d also like to see some way to make this field auto-dupe (next entry begins where the last one left off, end date defaults to start date, etc.) I use the Timer data type on a Time & Billing app that would benefit from those non-standard behaviors.