Candice_Mooney - profile

Candice_Mooney · Nov 06, 2022

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...

Candice_Mooney · Nov 09, 2022

Thats amazing! Thank you Adam. I am very grateful for people like you :grinning_face_with_big_eyes:

Candice_Mooney · Nov 08, 2022

Another challenge… Just testing the table and the input time 06:00 defaults to 18:00 previous day. Any idea how to fix this?

Candice_Mooney · Nov 08, 2022

Yes, that’s great! Thanks so much for taking the time to help with this!

Candice_Mooney · Nov 07, 2022

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...

Candice_Mooney · Nov 07, 2022

So I’ve copied the cells and the formulas but the results are not the same as yours? What am I doing wrong!?

User Statistics

User Activity

Substitute HH:mm in DateTime field with new HH:mm based on conditions

Re: Substitute HH:mm in DateTime field with new HH:mm based on conditions

Re: Substitute HH:mm in DateTime field with new HH:mm based on conditions

Re: Substitute HH:mm in DateTime field with new HH:mm based on conditions

Re: Substitute HH:mm in DateTime field with new HH:mm based on conditions

Re: Substitute HH:mm in DateTime field with new HH:mm based on conditions