3

So I got this calculated column called "Due time" with this format in it:

=IF([Hours]<24&&[Minutes]<60;CONCATENATE([Hours]&":";[Minutes]);"23:59:59")

I only get syntax error with this, can someone help me?

3

Assuming your Hours and Minutes columns are of number type.

Try Using below formula:

=IF(AND([Hours]<24, [Minutes]<60); CONCATENATE([Hours], ":", [Minutes]); "23:59:59")

Note:

  1. Sometimes comma(,) 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(,).
  2. Return your calculated field as Single line of text.

official documentation: Calculated Field Formulas.

| improve this answer | |
  • Sorry but this doesnt work for me :( Now everything under 23:59:59 gets the timestamp "23:59:59". I would like if its over 23:59:59 it will show that text. So It wont go start counting on the new day again. – 288088 Dec 7 '19 at 10:10
  • Can you please check adding one item which will have values: Hours less than 24 And Minutes less than 60? – Ganesh Sanap Dec 7 '19 at 11:29
0

If I'm not mistaken, it's the semi-colons - they should be commas:

=IF([Hours]<24&&[Minutes<60,CONCATENATE([Hours]&":",[Minutes]),"23:59:59")
| improve this answer | |
  • I got european region thing, so I have to use Semi-colons in my format :( Tried with commas also, but doesnt work. – 288088 Dec 5 '19 at 22:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.