I try to find difference between two date and time value in SharePoint 2010. I have two common column (date and time) and I use this formula =TEXT(Column2-Column1,"h:mm:ss") but it does not work? I get error "Invalid formula"

Could someone help me?


  • What is the locale of you site?
    – Andrew
    Commented May 21, 2013 at 10:10
  • Local is Polish
    – Wilon
    Commented May 21, 2013 at 10:39

1 Answer 1


Are you wrapping the column names in square brackets?


Reference: http://msdn.microsoft.com/en-us/library/bb862071(v=office.14).aspx

  • Yes of course I did it but still I have the same error "The formula contains a syntrax error or is not supported" Can I reach my goal by other method?
    – Wilon
    Commented May 21, 2013 at 9:55
  • There's a section in the article that says the delimiter may change from ',' to ';' depending on culture settings. It also says that the conversion should be automatic, but I would give it a try anyway. Have you tried testing it with DATEDIF?
    – pekoponian
    Commented May 21, 2013 at 10:05
  • I was also thinking to confirm if the input dates/columns are correct, but you mentioned that the formula itself is throwing the error.
    – pekoponian
    Commented May 21, 2013 at 10:07
  • I just tested it on a generic list with this formula, it works. It is also unable to accept the semi-colon as a delimiter in my case. =TEXT([Modified]-[Created], "h:mm:ss") ,returns single line of text.
    – pekoponian
    Commented May 21, 2013 at 10:22
  • You are big! I missed culture settings and when I changed "," to ";" It started works but now I am wondering if is formula which shows difference but with time and date? not only time like in this?
    – Wilon
    Commented May 21, 2013 at 10:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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