Sharepoint time calculated column
Posted on 2011-09-28
In Sharepoint 2010 I am trying to create a calculated date & time field so I can deploy a work load to send a reminder of an event.
I have 2 fields in use here: “Published”, which is the date from which the calculation need to be made and “Reminder” (the Calculated field)
“Published” is set to only show the date part for end users (& therefore I assume sets the time format at 00:00:00)
What I need to do is set the calculated field to be 15 hours before the “Published” field.
I can perform calculations to date days away, but not hours – how do I do this?