Hello, I am adding the new calendar view to an app (good addition!).
I am struggling to do what I consider should be an easy time manipulation. I have a field that contains the start day [Date] and the start time [Heure] and how long it took (in minutes) [Durée (’)]. I added a virtual column to create the end time… [End time]. Events happen in the middle of the day and never last more 6 hours so I can assume the end date is same as start date. So to use the calendar view, I just need to calculate the end time. So I want to make a virtual column [End time] that contains the result I want. Something like :
[Heure]+[Durée (’)]. Of course this throws an error as [Durée (’)] is not formatted as a duration like “000:30:00” for instance as per the onlide doc (https://help.appsheet.com/expressions/expression-types/date-and-time-expressions) . In fact, I do not find any syntax that works… I tried [Heure]+[Durée (’)]/60 hoping that it would magically take into account fractions of hours
precisely but it fails too (it does not throw any error but rounds it to the smallest integer as would do the Floor operator)…So, any idea to calculate an End Time base on a Start Time and a number of minutes? Best, Manu
LinkedIn
Twitter
