Is there any way that Date fields could be set up so that the Start and End date/time from a single date field can be called in the calculation as separate values?
Currently, as it was with Podio, the END date/time data isn’t truly accessible in calculation fields, therefore it requires two separate date fields in order to track the difference between a beginning and ending time.
Examples might be elapsed time for a project - measuring how many days/weeks passed before completion.
Or elapsed time from when a support ticket was received until it was completed.
Currently to run a calculation and measure the delta between those two times it requires two separate date fields in the template (see solution logged here.)
But this seems unnecessary, it would be preferred to be able to do all of this using only ONE date field where the End Date/Time can be completed based on an automation (aka when status is updated to = done) and then the elapsed time calc can run to show the total time taken.