SharePoint Calculated Column - Adding 3 hours to Now()

When using time to calculate when Now is in a SharePoint calculated column, you can add hours to it by doing this

If you want to convert it to a text value, do this:

=Text( Now()+3/24 , "hh" )   // hours

Share on Google Plus

About Tom DeMeulenaere

Highly accomplished information technology professional with extensive knowledge in System Center Configuration Manager, Windows Server, SharePoint, and Office 365.
    Blogger Comment


Post a Comment

Note: Only a member of this blog may post a comment.