This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello, I am new here. I am also new to formulas.
Have managed to work out the formula to calculate the number of 12hr shifts between two date/time fields.
ROUNDUP(((DATETIME_DIFF({DepartureDate},{ArrivalDate},‘minutes’) /60 ) /12), 0)
My struggle is...
Ok, yes, so I’ve checked and formatted all timezones to be the same and all seems to be fine now with the current data.
I also used your conditions formula for the ‘DepartureDate’ field and just swapped the ‘IS_BEFORE’ TO ‘IS_AFTER’ to make sure I ge...
