# Length of time in hours and minutes

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.

@RobP

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"
``````

1 Like

THANK YOU THANK YOU THANK YOU!

@RobP

You’re welcome welcome welcome. This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.