Prevent Duplicate Work Hours for a Single Technician
I require that my staff complete their work hours under the tickets they work along with having a daily work ticket that they put "administrative" work with brief descriptions. This has worked out very well. However, there are times where some of my technicians will end up putting overlapping work hours. For example, they worked Ticket 123 from 8:30am until 9:30am but they also worked ticket 124 from 9:00am until 9:30am. It shows up on the report for total hours as they worked 1.5 hours, which is physically impossible to do between 8:30am and 9:30am.
Two potential fixes:
* Prevent the user from doing this in the tickets, give them a warning saying they already entered work during this time (and output the conflicting information).
* Simply change the report to not duplicate the worked hours so in the example above, it would show a total worked time of 1 hour for that technician.