none
difference between times RRS feed

  • Question

  • pls help ...

    i have a table having data of various employees two columns are of time out and time in....time is stored in 24 hours format in mmTongue Tieds

    how to retrieve the resulet in new column named as duration

    Wednesday, November 26, 2008 11:43 AM

Answers

All replies

  • can u specify bit more.....time in - 12:15 and time out - 16:27 ??

     

    or time in - 27/11/2008 12:45:00 and time out - 28/11/2008 00:30:00

     

    ????

     

    Wednesday, November 26, 2008 11:48 AM
  • hheya i got the answer...

    datediff is the function to do that,,,

     

    Wednesday, November 26, 2008 11:54 AM
  • well i thought you might be aware of that function....and it might be not working and u need something more....anyways...glad that u r sorted....

     

    Wednesday, November 26, 2008 12:05 PM