Check if more than 3 hours

Question

I need a calculated column to display "Yes" if the current time is more than 3 hours after the value of another column. This is what I've come up with:

=TEXT(Today-[AddTime],"h")>3

But SP tells me this is invalid. Are there other ways of doing this?

Larsi

score 4 · Accepted Answer · answered Mar 15 '11 at 15:03

As you google around for this you are going to come across pages telling you you can do this with calculated columns using the [Today] trick.

You can't, it doesn't work and isn't updated dynamically - and even if it were [Today] doesn't include a time component so X hrs is out.

A couple of options for you

Use a CEWP and JavaScript to modify the display to show your Yes/No column.
Create a custom dataview usign SharePoint Designer/XSLT.
Use Workflow to run a job X hours after your record has been inserted to change the Yes/No column.

score 3 · Answer 2 · answered Mar 15 '11 at 12:14

3

You may want to look at this, it's a good primer for calculated columns. Also, Today and Me are not allowed in calculated columns.

answered Mar 15 '11 at 12:14

Eric Alexander

43,293
10
53
93

Handy link, I've included it in the tag wiki (to be approved): http://sharepoint.stackexchange.com/tags/calculated-column/info – Stu Pegg Apr 15 '11 at 09:50

Stu Pegg · Answer 3 · 2011-04-19T09:56:09.947

2

Excuse my self-promotion, but:

We've developed a custom column that can do just that, which is currently in Public Beta: http://www.pentalogic.net/sharepoint-products/highlighter/beta-testers-guide

To set it up to do this, you'd choose:

Highlighting
Display: Cell highlighting
Rules: Click "Add custom", then add the following two rules:

Rules example

edited Apr 19 '11 at 09:56

answered Apr 15 '11 at 09:35

Stu Pegg

4,623
7
48
91

score -1 · Answer 4 · answered Apr 15 '11 at 06:28

-1

This can likely be implemented not in a calculated column but in a computed column. The difference being that a calculated column is only calculated during edits, and a computed column for each render.

Wouter

answered Apr 15 '11 at 06:28

Wouter

713
4
7

1

I'm curious as to how one would implement a custom Computed column at all, to be honest. I was under the impression you'd have to inherit from SPFieldComputed, which is uninheritable. – Stu Pegg Apr 15 '11 at 09:25
You don't develop a computed column, you only configure it. E.g. and then use the render pattern to define the UI – Wouter Apr 19 '11 at 12:53
Oh, I understand. However, you don't have to use Computed in that instance, and I haven't come across a calculation-friendly version of ThreadStamp in the View Schema so far. – Stu Pegg Apr 19 '11 at 14:01

Check if more than 3 hours

4 Answers4

Linked