Calculating time Help Needed!!

[Scottie31]

I'm trying to write a query to figure out the time something was delivered. I have the following information to work with:

Estimated arrival time: 13:00
Loaded Time : 14:00
Trip Time : 2.5hr - - how do I conver this to Hr's & Min.?

I need to subtract the ETA & the Load time and then subtract half the trip time.

Any help would be appreciated
Thanks,

 

[mhartman]

Hello:

You want to use the DATEDIFF function. Set the interval to hours. Search online help

Regards
Mark