Timedate math works with days, i nees hours

Ask for Help
1

Hello guys

how to create a timestamp that works with seconds or hours?

The rows in my table are the meetings that have a duration - from hours to days

I have columns:

  • CreatedAt - populated with NOW at the creation moment: That is the Meeting start.
  • Duration - currently in days
  • MeetingEnd - CreatedAt + Duration

The problem is that this addition works with days only
How to add hours or seconds to CreateAt?

Many thanks
D

2
  • To add hours, use Date + X/24, where X is the number of hours
  • To add minutes, use Date + X/1440, where X is the number of minutes
  • To add seconds, use Date + X/86400, where X is the number of seconds
3 Likes