New answers tagged date-time
Are you wrapping the column names in square brackets? =TEXT([Column2]-[Column1],"h:mm:ss") Reference: http://msdn.microsoft.com/en-us/library/bb862071(v=office.14).aspx
Problem solved: Since I'm working with a dutch setup of SharePoint it never occurred to me to use dutch formulas. When I changed DATEDIFF to the dutch equivalent DATUMVERSCHIL it works like a charm. Very strange though, since some English formulas work, and not this.
Top 50 recent answers are included