Time Difference - Simple calculation 2

[jpkeller55]

I have searched many Time Differnce posts and can't seem to find an example of my problem.

I want to simply calculate in minutes the time difference between PrintTime and 4pm (ShipTime). ShipTime will always be 4pm (16:00)

For example:

Print Time TimeDiff
12:00 240
13:05 175
14:30 90

Thanks for any help!

 

[DotNetGnat]

use DateDiff() function...

-DNG

 

[jpkeller55]

I figured the DateDiff function wzas the way to go. How do I write it so it always calculates from 4pm?

 

[jpkeller55]

Figured it out...thanks!

MyTime: DateDiff("n",[PrintTime],"16:00")

 

[DotNetGnat]

DateDiff("n",#PrintTime#,#ShipTime#)

-DNG

 

[PHV]

And without function call:
(#16:00# - [PrintTime]) * 1440

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886