HI there,
I’m trying to create a formula that will look at the start date and time and then end date and time of an event (from two date/time columns) and give me the length of that event.
OR I can do so that I input that start date/time and how many hours (in metric - 1.5 for 1hr 30min etc) and the formula gives me the end date/time.
Are either of these possible?
Thank you.
Date calculations in monday can be tricky.
This should give you what you need for your first option:
INT((DATEVALUE(FORMAT_DATE({End Date})) + TIMEVALUE({End Date}))
- (DATEVALUE(FORMAT_DATE({Start Date})) + TIMEVALUE({Start Date}))) & " Days " &
ROUND(MOD((DATEVALUE(FORMAT_DATE({End Date})) + TIMEVALUE({End Date}))
- (DATEVALUE(FORMAT_DATE({Start Date})) + TIMEVALUE({Start Date})),1) * 24, 1) & " Hours"
Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or Excel)
THANK YOU THANK YOU THANK YOU!
You’re welcome welcome welcome. 
Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or Excel)
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.