MattBaldry
Self Taught, Learn from the Forums
- Local time
- Today, 11:13
- Joined
- Feb 5, 2019
- Messages
- 330
Hi all,
I am trying to get my head around the possibility of something, and hoping someone somewhere may already have this in the dust and cobwebs.
I want to be able to work out the end date/time of an activity based on start date/time, worked out based on working hours.
Example we have John Smith who works 07:30 - 16:00 each day, minus 10:00 - 10:10 tea break and 13:00 - 13:30 lunch.
If we enter an activity to start on Monday at 07:30 and takes 10 hours, I would like it to work out the end time to be 09:40 on the Tuesday.
I have worked this out as 600 minutes job time, 470 working minutes per day, so all day Monday (600 - 470 = 130) so 130 minutes into Tuesday, 09:40.
Hopefully my working out is correct and makes sense.
Each employee would have different working hours and break times. This will be recorded in a separate table.
Hopefully one of the amazing brains in here already has something in their memory locker....
~Matt
EDIT: Just to throw an additional table in the mix, I would also like to include the possibility of scheduled time off in this equation.
So if the above person had Tuesday booked off, it would show the end date as Wednesday 09:40.
I am trying to get my head around the possibility of something, and hoping someone somewhere may already have this in the dust and cobwebs.
I want to be able to work out the end date/time of an activity based on start date/time, worked out based on working hours.
Example we have John Smith who works 07:30 - 16:00 each day, minus 10:00 - 10:10 tea break and 13:00 - 13:30 lunch.
If we enter an activity to start on Monday at 07:30 and takes 10 hours, I would like it to work out the end time to be 09:40 on the Tuesday.
I have worked this out as 600 minutes job time, 470 working minutes per day, so all day Monday (600 - 470 = 130) so 130 minutes into Tuesday, 09:40.
Hopefully my working out is correct and makes sense.
Each employee would have different working hours and break times. This will be recorded in a separate table.
Hopefully one of the amazing brains in here already has something in their memory locker....
~Matt
EDIT: Just to throw an additional table in the mix, I would also like to include the possibility of scheduled time off in this equation.
So if the above person had Tuesday booked off, it would show the end date as Wednesday 09:40.
Last edited: