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