Sharepoint time calculated column

Dear Experts

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?

Many thanks
correlateAsked:
Who is Participating?
 
correlateConnect With a Mentor Author Commented:
Found the way round this ... was to divide the day up (ie. 1/2 day = .5 etc etc) - example below.

=([Publication Date]-.6
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.