Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Format Event End Time in UTC in ISO-8601 Format (no dashes)
/* 1440 minutes in a day */
TEXT( YEAR( ActivityDate + DurationInMinutes / 1440 ) ) &
LPAD( TEXT( MONTH( ActivityDate + DurationInMinutes / 1440 ) ), 2, '0' ) &
LPAD( TEXT( DAY( ActivityDate + DurationInMinutes / 1440 ) ), 2, '0' ) &
'T' &
LPAD( TEXT( HOUR( TIMEVALUE( ActivityDateTime + DurationInMinutes / 1440 ) ) ), 2, '0' ) &
LPAD( TEXT( MINUTE( TIMEVALUE( ActivityDateTime + DurationInMinutes / 1440 ) ) ), 2, '0' ) &
LPAD( TEXT( SECOND( TIMEVALUE( ActivityDateTime + DurationInMinutes / 1440 ) ) ), 2, '0' ) &
'Z';
@douglascayers

This comment has been minimized.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment