Search results

Thanks, That works great. The only other questions is.... I have the date and times in seperate fields. Is there an easy way of combining those fields without screwing everything up? Should I try to combine the date and times in the master table or will a query do the trick? Sorry to be a pain

Thank you for converting that database for me. I was able to open the sample you sent, however when I try and run the query i get the following error. Undefined function 'round' in expression. any suggestions?

Thank you guys for your solutions, however I am using an older version of Access (97) and cannot open the zipped files you have sent. Not sure where to go now.

I tried that but I get negative numbers when my time span crosses over midnight. Is there a simple solution for this issue? Thanks for your help!

Pat, I'm having trouble with the work around you suggested. Can you detail what it is I need to do to get my totals??? "Keep the individual differences in minutes and then sum the minutes. You can convert back to hours:minutes for display in the reporting step." Thanks,

Thanks Pat! I will try that and post back.

Hello all, I have a table where employees enter their begin and end work times. Those two fields are calculated (in a seperate query) to give the total number of hours worked for each employee that day called "TotalHours". In the table, the Begin Time and End Time are both date/times fields...

Thanks for the reply, I tried that formula and got "NAME?" error.

Paul, Is there any way to change the format of the formula to show "Total Hours Worked" as a number not a time format? If employee "A" worked from 0600 to 0200 the Total Hours shows 08:00. I would like the Total Hours field to show 8.0 Is this possible?? Thanks

Hey Paul, After changing the fields from Double to Date/Time it works like a charm. YOU DA MAN!

Let me change a few fields and see how that goes. I will post back later. Thanks for your help!

I found the error code problem was with a macro. After fixing that issue, the field "Total Hours Worked" will not total at all. I wonder if the fields I have are set wrong. Both time fields are set to general number. Sorry to be a pain, I have been working on this for days!

Hello pbaldy, Thanks for the quick response. I tried the formula you suggested and got the following error: "An expression you entered is the wrong data type for one of your arguments" What's wrong??

Hello all, I have a Form where users enter the hours worked for each day. I use a field on this form to calculate the total hours worked that day. For Example: Begin Time:1500 End Time: 2300 Total Hours: 8.0 Hrs The problem is when the user enters a Begin Time of 2300 hrs and an End...