Re: Query - adding time

Tech-Archive recommends: Fix windows errors by optimizing your registry

not sure what benefit of adding together login times tells you ??

if you need to know how long they have been working - you need:

logout (e.g. 17:30) minus login (e.g. 9:00) = 8 hours 30 mins




"shikha" <shikha@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1E4AD243-A91F-48D3-A3BC-C7F93CAECFF8@xxxxxxxxxxxxxxxx
Hi,

I have a field in table called login time formatted as short time, which
keeps record of login time into queue.

I am trying to do the query which would add the log in time such as 8:15 +
9:15 + 13:15 = 30:45. I am unable to do that.

any suggestions?


.