Solved Subtract hours

[MajP]

I guess I am confused now. I thought you decided to go with one event with a start and end time, not two events for clock in and clock out. Which one are you going with.

 

[zelarra821]

If your idea of three events seems ideal to me, and I think it's the right thing to do. However, you have taken a date that I do not know. I'll give you an example: I arrive at half past seven, and I register it as an entrance. At this point, I don't know when I'm going to stop. At eleven, I decide to take a break: I write it down. Now I have two records for day X. At this time, function 1 can be applied, called hours worked, just as you said. To do this, you have to take the difference between the times of those two records.

We went to breakfast, of which I already have the first hour: the start. When I come back, I write down the time. As before, I have to use function 2 in this case, which will take the start time of one record and the end time of the other record.

We continue. Now he would file and have the record with the start time of the second work period. When I clock in to go home, another record is created with that departure time. We apply function 1 that we have used above, taking the time of both registers.

All subtractions would be saved in a table along with the date, so you can easily add them later in a totals query.

I think that with that example it is clear that there would be three functions. Later he would need to calculate lunch, but it would be similar to what we have done for breakfast.

This has to be so because I don't enter an end date.

 

[MajP]

The whole idea is to get away from having to do two records for a single event. Instead every event has a start and end.
If it was me am logging every minute of the day. The next event starts at the end of the proceeding event

Work Block 0:730 - 11:00
Break 11:01 - 11:15
Work Block 11:16 - 12:00
Lunch 12:01 - 12:45
Work Block 12:45 - 16:00

For reporting Purposes you can calculate Start of day as 0:730 and end of Day as 16:00.

 

[zelarra821]

Yes, you are right, but I don't know how to get the start date of the day, which is in the first record, and the last one, which is in the last record.

 

[zelarra821]

Can you tell me how to get the start date of the day, which is in the first record, and the last one, which is in the last record?

 

[zelarra821]

What I do is write down the beginning of each of the events. I can't know, when I clock in, if I'm going to be working 2 hours or 1 hour, or if the break is longer and you only have to count half an hour... For this reason, I only want to manually note the start. Since @MajP recommended saving the ending, what I do is add a minute to it, but it's worthless to me. That's why I ask how I can search for the different types and then subtract them and finally add the results. That was my first question, because I tried to create an array to store the values and then go through them with a loop, but I couldn't, and I didn't know if my proposal would be optimal. I would like you to write me an example of what I have to do, to adapt it to my case. Thank you very much and sorry for the insistence.