Skip to main content

I have created this formula that will set the duration when something is selected:


SWITCH(


{Select},


‘Code Review’, 1200,


‘Design Review’, 1200,


‘Resume Review’, 1200,


‘Career Coaching’, 1800,


‘Team Coaching - Design’, 3600, ‘Team Coaching - Code’, 3600, 1200


)


It is then connected to another formula field to create and End Time:


DATEADD({Time}, {Duration}, ‘seconds’)



However, the time I get returned is 5 hours later not the minutes I have added. Anyone have a suggestions.

Can you post screen captures of both your record values and the configuration of your duration field?



Could your duration field be set to show h:mm but you are using it as h🇲🇲ss?

Can you post screen captures of both your record values and the configuration of your duration field?



Could your duration field be set to show h:mm but you are using it as h🇲🇲ss?


Something tells me this is a timezone issue. What’s the timezone setting on your {Time} field?

Thank you for the screen captures. That make things much more clear and showed that it was a time zone issue.





I thought this meant that the duration should have been 5 minutes, but the formula was adding 5 hours instead.



Instead, the result was adding the minutes you wanted plus an additional 5 hours, due to the time zone.

Reply


Terms & Conditions