Using Datediff but date and time data split

[Lenihan]

Hi, 

I had split my date/time columns for some calculated columns earlier, but, now, I've been asked to calculate difference between two dates, and for this I need both date and time. Is this possible to use datediff without having to rejoin these values back? I need to determine if a close date happens within 24 hours of the open date - so need to know both days and hours.  Is it possible in one formula to create a calculated column to determine the real # of hours between 4 columns?  (1. date and time fields when opened, and 2. date and time fields when closed)?

Thanks, 

Rob

[jthomson · Accepted solution]

I woulodn't have thought you'd have need to rejoin anything - the only time you need to be concerned about the time is if the start and end dates are precisely one day apart. Just go for a comparison like:

if (end date - start date) >=2 then "not within 24 hours", else

if (end date - start date) = 1 and (end time > start time) then "not within 24 hours" else "within 24 hours"

[Lenihan]

That makes total sense.. I'll give that a try when I'm done meetings today and see if it comes out right.

Thanks!