I am working in a calculate column that should calculate the time minus x minutes based on another date-time column.
I have a start date column of type date-time and I need calculate that time minus x minutes in the calculate column. Now the tryck is that the user will insert the amount of minutes in another column.
So the list looks like this:
StartTime AmountOfMinutes EndDate (calculated column) 2019-03-28 09:00:00 10 2019-03-28 08:50:00
I found a formula that extract 15 minutes and it looks like this:
The 4 in the formula represent 15 minutes. I need to use the user inserted time instead the 4 in the forumla. Or find some another way. After that a Flow will get trigged at the EndDate time. (MS Flow).
How can I use the user selected amount of minutes in the formula?
Best regards Americo