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

Now()+3/24

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

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

Source: https://sharepoint.stackexchange.com/questions/216022/how-do-i-add-hours-to-now-after-converting-it-to-a-text-value

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.