Sullster47
Last Activity: Feb 13 '23, 11:06 AM
Joined: Jan 31 '23
Location:
-
Yes I have found an added issue as I have to take their breaks off the final time as well. Now I have the easy ones done, I have to work out the hard one where the rate paid depends on which time band it falls into and they often fall into 3 bands! I am working through it but couldn't have done it without your input. -
MyStr = DateDiff("h", MyTimeIn, MyTimeOut)
This returns the correct value.
NeoPa, thank you so much for your help. You have been a massive help and I am deeply indebted to you.
Thank youLeave a comment:
-
Thanks. I have combined the Booking Date field with the Booking Time In field which gives me the correct format date so that when I do the same with the TimeOut, I can add a day if the TimeOut is less than the TimeIn (04:00 < 20:00).
This now works to give me the 04:00 in the next day but how do I then work out how many hours between MyTimeOut and MyTimeIn?
MyTimeIn = Bookings!MTIn (returns 07/02/2023 20:00)
MyTimeOut = DateAdd(Interva l:="d",...Leave a comment:
-
Argh the ramblings of a programmer mid-flow.
Apologies for this.
I am using the start time of the next rate to work out the end of the current rate. This way I dont hold duplicate data.
All works well until a shift goes across the date line into the next day.
I dont know how to add a day on to the shift time to work out the hours worked.Leave a comment:
-
Calculating Rate hours for late shift running after midnight
I am stuck on this and would love some help. I have a customer who has 3 rates of pay and personnel can in theory go across all three. Working out the rates 1 & 2 are simple as they are in the same day but the 3rd rate goes across midnight. Rate 2 starts at 18:00 and runs till 00:00(24:00). The code below works until we cross this time and then it fails. When I ask the question: is the end time later than rate 3 start time (which means I need...
No activity results to display
Leave a comment: