0

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?

Thanks,

  • What is the locale of you site? – Andrew May 21 '13 at 10:10
  • Local is Polish – Wilon May 21 '13 at 10:39
2

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

  • 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 May 21 '13 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 May 21 '13 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 May 21 '13 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 May 21 '13 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 May 21 '13 at 10:28

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.