Do you know any guides/tutorials for Time related formulas? ๐Ÿ“–

I am trying to figure out how time formulas work.
I would like to find some basic guide to help me understand these concepts.

I have looked through the community and found explanations for certain situations, but I would like to understand the underlying concepts.

Any suggestions?

Hi Fran

I have just started on the Dates section of formulas in my formula reference manual.

Did you have any specific questions in mind? Or formulas, then I can prioritise create examples of those.


1 Like

The main reason I asked this question is because I wanted to create a countdown timer and I found a solution in the Community but it gave me an absurd result.

Thatโ€™s when I thought I needed to grasp the concept of how dates and times are being subtracted/added to each other.

But it turns out itโ€™s quite simple, I just typed day value in month valueโ€™s spotโ€ฆ :blush:

1 Like


One just needs to bear in mind whether the formula actually works with date/time value, or the underlying โ€œepoch numberโ€.


1 Like