Calculating the minutes from a start and end time

I am interested in a way to calculate the minutes between a start and end date and time.

Outlook integration allows you to automatically pull the start (date and time) and end (date and time) of a meeting into a monday board. What I want to do is calculate the minutes for each meeting.


Assuming that you are using date columns and that the start and end are on the same day, this formula will return the time difference in minutes:

IF(AND(LEN({End Date}) > 10, LEN({Start Date}) > 10),
      TIMEVALUE(FORMAT_DATE({Start Date}, "Y-M-D HH:mm"))), 24), 60), "")

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

This worked, thank you so much Jim

1 Like