Hi all, i’m new to Monday.com. I have some issues where I have these columns:
First i calculate the Minutes Difference based on the Start DateTime and End DateTime columns, the expression is as below:
DAYS(
- {End DateTime},*
- {Start DateTime}*
)2460
Then, from Minutes Difference, I created column named Formatted Duration in HH:MM:SS format, the expression is as below:
TEXT(
- FLOOR({Minutes Difference} / 60),*
- “00”*
) & “:” &
TEXT( - MOD({Minutes Difference}, 60),*
- “00”*
) & “:00”
Next, I separated the HH and MM from the Formatted Duration (HH:MM:SS) column and created new columns named Hours and Minutes.
The problem arises when, Hours = 0 and Minutes = 60, which seems to be caused by the Formatted Duration column = 00:60:00 (60 minutes). Could you help me identify what’s wrong with the expression? Why the 60 Minutes display as 00:60:00 instead of 01:00:00? because in the correct time format, 60 minutes should roll over to 1 hour, resulting in ‘01:00:00’ instead of ‘00:60:00’.
Thank you in advance 