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

1 Like
3

This worked, thank you so much Jim

1 Like
4

That’s really helpful Jim. What changes in this formula if we want the result in hours?

5

@Fernanda

The easy way would be to just change the “60” to “1” in the previously given formula.

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

1 Like
6

Take starting time and subtract it from ending time. Multiply the hours by 60 to convert it into minutes and add slope unblocked it to any amount of minutes you have left after the subtraction . If you have any number of seconds left after the subtraction, divide the value by 60 and add it to the final result. That’s all!

1 Like