CODEWITHSUNDEEP
sharepoint
walming
walming

Reputation: 392

How do I get time for a calculated column

In SharePoint [Today] returns 12:00 PM. How do I get current time?

Trying this as value for column "=Today+TIME(Hour(Today);Minute(Today)-10;0)".

This is for new items and it's to set default value for a DateTime column.

Upvotes: 2

Views: 1775

Answers (1)

Alex Angas
Alex Angas

Reputation: 60027

As far as I am aware you can't use times with Today in a calculated column. Also if you aren't already aware, Today does not update automatically, only when you edit the list item.

JavaScript is the most common solution to this, although it's a little difficult to know what the options are without the full details. If you re-edit your question with exactly what you would like to do we can help further.

Upvotes: 2

Related Questions