Skip to Content
0
Feb 20, 2009 at 12:02 PM

Differnce in Time

22 Views

I want a query for getting difference in timings of two coloumns..

my query is getting time in the format hhmm(1417) for 02:17 pm..

i want a function which can calculate the time difference..for an example

for create time is 1842 and close time is 1912 the difference sholud come 30 mins........

Help me!!!!!!!!!!!