Formulas - HOURS_DIFF({Check-in (Hour)},{Arrive (Hour)})

[carolin-skiply (Caroline Bouchat)]

Hi,

I am having an issue with the formula HOURS_DIFF({Check-in (Hour)},{Arrive (Hour)})

when entering :

• {Check-in (Hour)} = 11:59 PM
• {Arrive (Hour)} = 12:01 AM
  I got :
  
  
  It should give me “-00:02”.

Best Regards,
Caroline.

[rob (Roberto Tremonti)]

Hey @carolin-skiply
Considering times are in the same day, the result is correct.

12:01 AM (right after midnight) is before 11:59 PM

[carolin-skiply (Caroline Bouchat)]

Hi @rob

Thanks for reply. I figured that out and added the days… in formula.
Now it’s working.

[AlexSavchuk]

Hey @carolin-skiply

I’m really happy @rob was able to provide a helpful pointer here. Just to clarify, the monday.apps and developers section is meant for questions related to using the monday.com API, SDK and No-code solutions to create connections between platforms, or to create monday.apps. While we’d be happy to help out with Formulas too (I myself am a big fan of the Formula colum), I’d appreciate this thread to be posted in the right section I hope that makes sense.

-Alex