I have two time variable : time_in and time_out. ineed to get the difference of these two time and add the resulting time difference and sum it up.
can somebody tell me how do get the difference between time_in and time_out and the summation of the differencce time variable in hours minutes and seconds.
Have a look at the attachment, just open the form and look at the examples (24 hour clock). However if you enter say start time 7:00 AM - it will show 07:00 then if you enter endtime 7:00 PM it will show 19:00
If you open the query you will see how it works.
NOT MY IDEAN, JUST SOMETHINK I PICKED UP IN MY WEB TRAVELS.