Time Zone Calculation Differences Between Boards and Docs

Platform discussions
,
1

I have a Date column (contains a date and start time) and an Hours column (contains a decimal number of hours (i.e. 1.5 = 90 minutes).

A formula column (D/T Calc) concatenates that data into a string like, “Monday, December 1, 4:00 - 5:00 PM.” That formula works; here it is:

CONCATENATE(FORMAT_DATE({Date}, "dddd, MMMM D"), " from ", IF(MOD(HOUR({Date}) - 0, 12) = 0, 12, MOD(HOUR({Date}) - 0, 12)), ":", IF(MINUTE({Date}) < 10, CONCATENATE("0", MINUTE({Date})), MINUTE({Date})), IF(HOUR({Date}) >= 12, " PM", " AM"), " – ", IF(MOD(FLOOR(({Hours} * 60 + (HOUR({Date}) - 0) * 60 + MINUTE({Date})) / 60), 12) = 0, 12, MOD(FLOOR(({Hours} * 60 + (HOUR({Date}) - 0) * 60 + MINUTE({Date})) / 60), 12)), ":", IF(MOD(({Hours} * 60 + (HOUR({Date}) - 0) * 60 + MINUTE({Date})), 60) < 10, CONCATENATE("0", MOD(({Hours} * 60 + (HOUR({Date}) - 0) * 60 + MINUTE({Date})), 60)), MOD(({Hours} * 60 + (HOUR({Date}) - 0) * 60 + MINUTE({Date})), 60)), IF(MOD(({Hours} * 60 + (HOUR({Date}) - 0) * 60 + MINUTE({Date})), 1440) >= 720, " PM", " AM"), " ET.")

That all works fine. The resulting value is correct in the D/T Calc column.

But when I generate a template-based Monday Doc that includes that Dynamic Value, the time(s) are wrong. Instead of a 1:00 PM start time, I get 6:00 PM. The five-hour discrepancy suggests a UTC-to-EST time difference.

  1. Why on earth would time calculations be different in the Board and Doc?
  2. What can I do to make this work correctly (other than just manually correct for this madness)?
2

Have you reached out to support? I feel like that is a bug… support@monday.com

Desiree - www.thecleverclovers.com

3

No… I assumed it was “supposed” to work this way for some ancient reason.

Will they see this post, or do I have to reach out directly?

4

I’d recommend reaching out to them with your info so they can review directly.

5

To follow up, I had a couple of lengthy chat sessions and video exchanges with Samuel D on the support team, and he confirmed and recreated the issue. His latest missive says, “I just wanted to let you know that our developers have confirmed that this monday doc/formula column issue is a known platform limitation. I am now inquiring if this limitation can be addressed and fixed, and I will continue to keep you updated!”

So that’s something.

1 Like