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,

Improve this question
2
  • What is the locale of you site? Commented May 21, 2013 at 10:10
  • Local is Polish Commented May 21, 2013 at 10:39

1 Answer 1

Reset to default
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

Improve this answer
5
  • 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? 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? 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. 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. 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? Commented May 21, 2013 at 10:28

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.