I do maintenance for a living and just dip my toes into this kind of stuff but you had a question whose answer I thought could help me out.
Here is what I have come up with so far.
Appointment Column is a formula running this exactly:
DATETIME_FORMAT(IF(Minutes < 1, CREATED_TIME(), DATEADD(NOW(), Minutes - 1, ‘minute’)), ‘MM-DD-YYYY hh:mm a’)
Minutes is number column where you strictly type the minutes to be added.
I found some issues that would need to be addressed with my code and/or your situation.
A starting point needs to be decided, and it needs to be known if this starting point changes ever. You have an example for one day and a starting time. Is that starting day and time an input?
I was trying to find a solution of not putting a minute input into the minute column, and using the lack of input along with an If statement to then “reset” the day/time from which you could continue adding durations.
I hope this helps!!
Edit: This works better, and I might have a solution here shortly… but this is the latest:
DATETIME_FORMAT(IF(Minutes < 1, CREATED_TIME(), DATEADD(CREATED_TIME(), Minutes - 1, ‘minute’)), ‘MM-DD-YYYY hh:mm a’)
Edit 2:
Tried using MAX(Values) to automatically grab the latest date/time to which add the duration for populating the cell. Max(Values) only seems to work in a niche case with dates. You need to use MAX(Values) in the aggregate section of a RollUp column which references a DATE COLUMN TYPE ONLY, otherwise it does not work. Without this functionality in a formula type column, I assumed you would have to use a LOT of functions to turn the dates and times into test strings, then number strings, then finding the max year, then month, then day, then time, then turning that back into a useable format. Seems like a big nested mess would be required, but I think it is doable.
