I'm trying to make a custom ammount of time? for the duration of an event in my calendar view, this view is associated to a google calendar and when the event is created then is automatically added an duration time of 30 minutes to the end column of the event if format datetime for start and end columns like follows:
[Start]: Initial value: now()
[End]: Initial value: [Start] + "000:30:00".
if I do de following formula for the End column (with the duration column is of the type text):? [Start] + CONCATENATE("000:", [duration], "00") then it doesn't work at all, the result of the concatenate is a column with the same format as the original (000:45:00) but appsheet doesn't allow the sum of times and the part of the 45 minutes appears empty in the test. If I use TIME(0,[duration], 0) with the duration column of the type number, it also doesn't work.
the [duration] column is in another table that contains the duration of the event which I want to establish from the configuration menú created for the app. I've been trying with gemini but it doesn't give me the solution.
How can I do the custom added time for the End column?
