Calculating the minutes from a start and end time

Platform discussions
1

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

Application.
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.

2

@jacquigraham

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),
   MULTIPLY(MULTIPLY(MINUS(TIMEVALUE(FORMAT_DATE({End Date}, "Y-M-D HH:mm")),
      TIMEVALUE(FORMAT_DATE({Start Date}, "Y-M-D HH:mm"))), 24), 60), "")

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

3

This worked, thank you so much Jim

1 Like