Hello!
for my flow I need the difference of two Outlook calendar timestamps to add/subtract to another timestamp. The results then in the same time format.
To calculate the time difference I use
div(div(mul(sub(outputs('CalendarItemA'),outputs('CalendarItemB')),100),1000000000),60)
This gives me the time difference in minutes.
How can I now subtract this from a CalendarItemC or add to that?
Could it be possible to fulfill the requirements by calculating this way:
Thank you for any help!
Could it be possible to fulfill the requirements by calculating this way:
Hey @ultrAslan
you can use
addMinutes function for this.
Default expression:
addMinutes(timestamp, minute to add or subtract, optional: format date time)
For adding minutes use:
addMinutes(outputs('CalendarItemC'),outputs('TimeDiff'))
For Subtracting just use a negative sign in the above expression:
addMinutes(outputs('CalendarItemC'),-outputs('TimeDiff'))
User | Count |
---|---|
23 | |
15 | |
14 | |
10 | |
9 |
User | Count |
---|---|
45 | |
29 | |
25 | |
24 | |
22 |