Solved

Sharepoint time calculated column

Posted on 2011-09-28
1
493 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
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
A short film showing how OnPage and Connectwise integration works.

914 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now