Formula for time

Platform discussions Special workflows & use cases
, , ,
1

Hello!

Would anyone know what formula I can use to get the elapsed time from a date column that has a time attached to it?

Thanks

2

Hi Jose,

Try:

FORMAT_DATE({Date},"HH:mm")

 

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

3

Hello Gilles! Thank you very much for your reply.
I tried the formula you shared with me, but it only gives me a time, it doesn’t tell me how much time has passed from a date and time.

Basically, what I want to simulate is the last update column, but for a workflow I require to do it in formula column.

4

You mean you want the difference between the date and now?

In days:

DAYS(TODAY(),{Date})

In hours:

DAYS(TODAY(),{Date})*24