I have a formula that I found online and I am not coder so I don't know if this is correct or not but I took the code and am getting errors right off the bat. Can someone look at this and tell me what's wrong with it?
Here is the full string:
=CONCATENATE(TEXT(HOUR([Finish Time]-[Arrival Time]),"#"),":",TEXT(MINUTE([Finish Time]-[Arrival Time]), "#"))
I have a date/time field called Arrival Time and one called Finish Time. I have a text field (according to the article) that I am trying to set the above formula as it's default value. I have also tried using a rule where Finish Time is not blank then run this formula. But the formula itself errors out starting with telling me that the brackets are not correct, I take out the brackets and then it goes to the work HOUR.
I am working in a SP Online list and just need to do a finish time - start time. Not sure if it will always be within 24 hours but pretty sure it will, so I don't need to worry about that, unless there is an easy way to add this.