How to calculate Time diference between 2 Time Feilds 1

[number2]

How can I calculate the time difference in hours and a 1/4 hour increment? I tried the DateDiff function with no luck.

 

[tomschafer]

Try this expression...

1 / (10 / (DateDiff("n", Date1, Date2) / 6))

 

[number2]

Thanks, it almost works. I can get it to calculate the number of hours and the number of 1/4 hour units. I need to get it to round off to the nearest 1/4 hour. Any ideas?

 

[tomschafer]

You want it to return a date value? If so just use dateadd. example:where DateValue is your Start date...

dateadd("h", (1 / (10 / (DateDiff("n", Date1, Date2) / 6))), DateValue[/red])