Recent content by MattBaldry

The issue is they may have logged onto different worksorders at the same time, so I need to use the earliest start time and latest end time within the same time period. The 4 below are all different orders worked on at the same time. 31/10/2024Employee One07:19:5010:51:5203:32:02...

I was lazy and used Excel and didn't check the workings out. You are correct, I will do them properly :)

This would be useful, but I have no idea were I would start on this. ~Matt

Those 10 seconds are not logged because they logged off a job at 10:52:03 and then logged onto a new job at 10:52:13. I know on this example it is only 10 seconds, but other people have greater time between a log off and log on. If we take the below example of a different employee, you will see...

Hi all, I have the below table and I want to work out how many hours worked in a day based on the earliest start time and latest end time a person has logged on. In the data below we can see that Employee One logged on to 4 jobs around the same time, starting at 07:19:50 and ending these at...

No, I have given up on this at the moment. Sadly other things have become more important, so this is on the back burner for a while.

I simply use the below. Private Sub Form_Activate() Me.Move 10, 10 End Sub This works fine for me. And I have different locations for other forms. ~Matt

Hi Larry, No, this would only be needed to work out when an activity should end based on how many minutes it should take, and when it should start. It is just a start and end formula needed. ~Matt

Thanks Doc, You have explained it very well and you are right. I need to find a way of taking the start date and then adding all minutes needed for the activity, including any breaks, out of hours times, public holidays and such. For now, if I can get a way of just taking the start time and...

That does make sense. I feel your pain of people and entering of data. I have had to write more code than I would care to make simple entry foolproof. And I still get amazed some days on what people have done.

Hi Larry, Thank you for the db. I have had a quick look and wonder why you have separate fields for the date and time? If you have these in a single field, you can just use the DateDiff to get the answer your formula shows. DateDiff: DateDiff("n",[ActivityStartDate],[ActivityEndDate])/60 This...

Hi plog, At the moment I am as basic as below for the employee side. EmployeeID, EmployeeName WorkingHoursID, EmployeeID, MondayStart, MondayEnd (and remaining weekdays) TeaBreakID, EmployeeID, MondayTeaStart, MondayTeaEnd (and remaining weekdays) LunchBreakID, EmployeeID, MondayLunchStart...

Apologies, I got over excited. The tea break should have been 10 minutes.

Skiving time 😆 they have more of that than anything.... ~Matt

Hi plog, I have tried this, but I need to add the time only during the working hours. If I add 600 minutes to 07:30 I would get 17:30, not 09:40 the next day when you take out the breaks and out of working hours.... ~Matt