So I got this calculated column called "Due time" with this format in it:
I only get syntax error with this, can someone help me?
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
Minutes columns are of number type.
Try Using below formula:
=IF(AND([Hours]<24, [Minutes]<60); CONCATENATE([Hours], ":", [Minutes]); "23:59:59")
,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(
;) instead of comma(
official documentation: Calculated Field Formulas.