Solved

Sharepoint time calculated column

Posted on 2011-09-28
1
518 Views
Last Modified: 2012-08-13
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
0
Comment
Question by:correlate
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
correlate earned 0 total points
ID: 36718326
Found the way round this ... was to divide the day up (ie. 1/2 day = .5 etc etc) - example below.

=([Publication Date]-.6
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question