I currently have this formula in a calculated field in SharePoint.

=IF(TEXT(Created,"mm/dd/yyyy hh:mm")="12/30/1899","",(TEXT(Created,"mm/dd/yyyy")))

This returns the Created Date in Text form.. but since our SP server is on the west coast. There is a 3 hour lag in time.

How would I add 3 hours to this formula?


Since adding Specific numbers is whole days, [Created] + 1 would be Adding 1 day, you can cut the value in to 24 parts and add specific hours.

[Created] + (3/24) for 3 hours


Try this.


referenced thread

enter image description here

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.