• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 529
  • Last Modified:

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
1 Solution
correlateAuthor Commented:
Found the way round this ... was to divide the day up (ie. 1/2 day = .5 etc etc) - example below.

=([Publication Date]-.6
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.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now