Search results

Just to test if it was the Holiday list giving me the problem I removed the IF statement: 'Check for the holiday. If the date is a holiday, then we remove one day If Not IsNull(DLookup("[HolDate]", "Holidays", "[HolDate] = #" & Int(StDateD) & "#")) Then Result...

Ok, If necessary I can just remove the holiday portion. It's not that big of a deal. However, I don't quite understand how to implement Cronk's suggestion.

I did both but now I just get whole numbers. For the same record we have been previously referencing, the worked hours totals "30519". Just to give you a few options...If I add back the "/60" I get the following "508.65" This is the query formula: WorkHours...

ok I also removed the "/60" from the query, but now I get all "00:00:00".

Thanks Grumm. yea I have the query dividing by 60 only, I dropped the "/24". It helped but somehow we are just a tad off. I am trying to educate myself as we go along but still not coming up with much. I truly appreciate any help you can provide!

Grumm - In the query I removed the "/24" and it does look closer but still not right. For the same record you reference above it now shows 15:36:00 (which is higher than more than the previous 04:39:00). Cronk - I did toy with changing the MinDay for 480, however it didn't help. I believe...

Ok I understand where you are going now. However, I have to show total worked hours, not days. This goes to my boss and they do everything by hours. So how else would you suggest I get the total hours when they go past 24 hours?

Whatever the issue is keeps pointing to the "Result = Result + MinDay" of this section: Do Until StDateD = EnDateD 'If the date is not a saterday or a sunday we add one day. If (Weekday(StDateD) > 1) And (Weekday(StDateD) < 7) Then Result = Result +...

I'm not quite sure I follow you so if I am missing something obvious I apologize in advance. If a project took 90 days I don't really care to show number of days as much as I want to show how many hours were worked during that time frame. So what I can tell from your postings is that my...

I am also getting a Runtime Error '6': Overflow and on debugging it highlights: Result = Result + MinDay

Thanks for all your efforts on this Grumm! I am extremely appreciative. I am seeing a problem in the query results though. I have one line, for example, that the start date is 05/18/2015 12:21 PM and end date is 8/15/2015 5:00 PM. It is giving a result of 04:39:00. I haven't calculated what it...

Thanks Cronk...however....for what this is used for there is no need to calculate in a lunch break. I could see how that would be very useful under different circumstances though.

Thank you so much for your help! If the request was received after hours then the counted time should start the following work day at 8:00:00. Thanks again for your help!

Yea I am US and its mm/dd/yyyy. If it helps in the code you are working on I am already using the below code for NetWorkDays to get the works days for another query in the database, it also excludes our business holidays. Public Function NetWorkDays(dteStart As Date, dteEnd As Date) As Integer...

Thanks a lot Grum. I appreciate the help! However, again, I am dealing with VBA code here that is beyond my current knowledge. I hate to be a pain but I guess I am needing help by someone making changes to the code I posted. Since I don't know exactly what I am doing on this code I would...

Thanks for the reply Cronk. To be clear, my VBA skill level is self-taught and by searching all the forums for the answers I need. I searched all the forums and this was the closest I could find to meet the needs of what I was trying to achieve. I don't know what I am looking at on most of this...

Hello everyone, I have the below code I recently snagged from a posting. I thought it was working until I saw that on cases where the start time , for example, was 05/06/2015 5:09:00 PM and the end datetime was 5/7/2015 8:15:34 AM if gave a value of 00:08:00 instead of 00:15:34. Public...

Thank you so much Paul for responding so quickly. I'm sure you are extremely busy so I hate to ask if you could go into a bit more detail. I'm a self-taught Access user so sometimes the technical terms evade me. It sounds like your process is simple but I'm a little lost at how to begin.

Currently in an access database I have a query that runs off of a parameter form. The parameter form collects the [Start Date], [End Date] & [Office Name]. Once a user enters the [Start Date] & [End Date], the [Office Name] combo box auto populates with list of Office Names that were entered...

Sorry looks like we posted at the same time. Yea it looks like I did what you were going to suggest. Awesome! Works like a charm. Thanks for all the patience and help!