Shift selection

C

Cesarini

Hello boys:

I need to select the current shift from a table. The table has 3 shifts
stored:

ID Start End
1 07:00:01 am 03:00:00 pm
2 03:00:01 pm 11:00:00 pm
3 11:00:01 pm 07:00:00 am

I need to select the current shift regarding to the current time.

Any help will be appreciated,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting time...again 2
separating date and time 5
Difference between two times 5
Determine if night shift by start & end time 2
Array | Matrix - Formula??? 0
HELP! What's Up With Time 2
Time Calculation 1
Using VBA to create charts 1

Top