By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,039 Members | 1,831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,039 IT Pros & Developers. It's quick & easy.

how to sum up the total worked hours in access query

P: 3
HI

i have one column in a query which give total worked hours in the format like 09:00, 08:53.. How can I sum up all those
hours ,
for eg;
emp id date in out total worked
122 12/1/2011 09:10 18:00 08:50
122 12/2/2011 08:30 18:10 09:40
------
18:30

or is it ok it could be done in reports..but how?

i am very new to access. and thanks in advance

shas
Jan 4 '12 #1
Share this Question
Share on Google+
3 Replies


TheSmileyCoder
Expert Mod 100+
P: 2,321
First you need to supply the field type for all fields involved.
Jan 4 '12 #2

P: 3
Hi TheSmileyCoder

thanks for your replay

the query is for calculating the difference between login time and log out from the table "punching"

punching table
emp id number employee id
login general date
logout general date

total time query


SELECT [punchng].[emp id], [punchng].login, [punchng].[log out], Sum([punchng]![log out]-[punchng]!login) AS [Total worked]
FROM punchng
GROUP BY [punchng].[emp id], [punchng].login, [punchng].[log out];


the total worked field type is "short time"

thanks
shas
Jan 5 '12 #3

P: 3
I have got the answer from http://office.microsoft.com/en-us/ac...001110218.aspx
thanks
Jan 6 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.