dtolemy
Last Activity: Nov 5 '17, 01:38 AM
Joined: Apr 18 '17
Location:
-
Phil, this is now working as expected, thank you again so much for your help. Dave -
Phil I manual figured out the difference for the 22/05/2017 09:45:00 and the end date of 24/05/2017 14:50. Based on the table where Monday thru Friday is 6:00 am to 22:00 pm it does come out to 37.05. If you add 1 hour to the end date and make it 15:50 pm when you calc it should show 38.05 because you are adding an hour instead, it shows 36.05 which is actually an hour less. I went back and re loaded your original program which is the same as I had...Leave a comment:
-
Phil, I tried the code but I am still getting the same result it's almost like it should be reverse Like if I change the end time from the original 2:50 to 1:50 it should calculate down from 37.05 to 36. 05 and yet it calculates it up going to 38.05. When I change the time form 2:50 to 3:50 it should calculate to 38.05 and instead it calculates to 36:05 so instead of adding it is subtracting. I am including a file that has the latest code that I...Leave a comment:
-
Phil, Are you out there? I am having an issue with the code above and not sure why. If I add an additional hour to the example above and make the end date 5/24/17 15:50 PM instead of adding an hour to 38.05 it subtracts and hour and makes it 36.05. What do I need to change?Leave a comment:
-
Thanks again Phil for be so patient with me and helping me through this.Leave a comment:
-
SO, I actually changed the TotalTime field to a text field and it now works, gosh I feel so stupid. I now have a working model so I can complete my original DB thank you so very much I can't tell you how much this helps me out.Leave a comment:
-
OK so I really am an idiot, I went back and made sure all of the DIMS are exactly like how you have them originally listed, I now get all the way through up until the last line of the code which is "TotalTime = HrsDiff & ":" & Format (SumMins, "00")How should my field total time be setup as a number, text, or calculation? I also went back and changed the HrsDiff to Long.Leave a comment:
-
Phil, I am attaching an excel file that shows the two tables and the form I created. I have also included the code you gave me am I missing something that I do not see? I know sometimes I can be pretty blind. Dave...Leave a comment:
-
Phil, First off thank you for your help, secondly I tried stepping through with the break point and the only thing I still see is that it flags the same line I stated before. I then changed the HrsDiff as Long and the same thing happened. The dates I am trying to run are SD 05/23/2017 9:45 AM ED: 05/25/2017 2:45 PM. I even tried changing the date structure to DD/MM/YYYY and still the same result. WHat I did do was create a new table called TblDays...Leave a comment:
-
Phil, I have input the code you showed above and have tried to run it. Every time I do I get an error message "Run-Time error "6": Overflow" starting with the following code:
'Full days between Start Date & End Date
FirstFullDate = DateAdd("d", 1, StartDate) 'First Full Date
I have been trying to figure out what I am missing, but I am not having any luck....Leave a comment:
-
Phil, I got two good answers yours and Jforbes, I am going to try them both to see which one will work the best for me in what I am trying to do. I really appreciate your help on this.Leave a comment:
-
Thank you so much for your help, I will give it a try and see what happens.Leave a comment:
-
Specific Date and Time calculation
I am trying to calculate the amount of time spent on an issue if the work week is Monday thru Friday with a time frame of 6 AM to 10 PM only and Saturdays with a time frame of 8 AM to 6 PM. No Sundays. Following is the scenario: I open a ticket on Monday morning at 9:45 AM but do not close it out until Wednesday at 2:50 PM. I can only include the time frame of 6 am to 10 pm for all three days. Looking for an answer of 37 HRs and 05 minutes. Is there... -
I wanted to thank you for your help. I have decided to go back to the drawing board and completely redo my DB. I think I can stream line it more now and really get it to do what I need it to do. As you stated plan, plan plan. Thanks againLeave a comment:
-
You are correct, I have a table called outages that holds my dates and all of the data as it is input. I also have a table called Employees that holds my Tech Names and their managers. My outage table also has the tech and manager name, but when I set them up in the outage table, I set them up as numerical fields so when I look at the data in a datasheet view instead of seeing the actual names I see the numbers associated to them.
All...Leave a comment:
-
I have a DB that I created that contains Outages that we have. I have the techs assigned to the outage along with their manager that they report to. I also have the date the incident occurred and the date it was resolved. The issue I am having is that I want to be able to report the outages by the Tech that was assigned to them along with the start and end date of each outage.
I have created a report and I can either pull in the start...Leave a comment:
-
Create Report with one user name and dates
I have a report that I have created and I have a VBA as well but it is only pulling in the dates like start and end it is not allowing me to pull in the employee name as well so that I can produce a report by specific dates and by a specific employee. What am I doing wrong.
No activity results to display
Leave a comment: