I would like a function created to store a shift time
Earlies - 07:00-15:00
Lates - 15:00 - 23:00
Based on the current system time i would like a function call Current shift to give me the output of in the region of e.g. 08:37 would give Between (Date()+#07:00:00#) And (Date()+#15:00:00#)
17:41 would give Between (Date()+#15:00:00#) And (Date()+#23:00:00#)
23:58 would give Between (Date()+#23:00:00#) And (Date()+1+#07:00:00#)
01:54 would give Between (Date()-1+#23:00:00#) And (Date()+#07:00:00#)
This function would then be used in Queries criterias
13 freelancers are bidding on average £19 for this job
I have extensive knowledges in MS Access and Excel, especially in VBA. I've read and understand the description, I'm sure can work and finish this project as requested.
hello. how are you? i am expert of Microsoft Excel, excel VBA and data analyst. i have many years of experience on like these job. i can satisfy every thing what you want in short time. best regard.