How to handle time calculations with PM and AM next day transactions 1

[Pack10]

I am buiding a time on routine, we want to show how many hours something has been on the database until it is closed out, for instance if an item gets assigned at 5 PM the previous day that is hour 17....and the next day at 8 AM my calculation shows -8, when it is really 15 hours.
how can I show the number of hours it has been on the system.

 

[lameid]

I expect the datediff function is what you want. You just need to be sure to pass it date and time together with the correct parameter of hour.

 

[SkipVought]

be sure to pass it [highlight]date and time together[/highlight]

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

be sure to pass it [highlight]date and time together[/highlight]

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Pack10]

Worked like a charm,...thanks