handling times between dates

[chriswrcg]

I have a database that requires me to enter new records for the various shifts that work in my warehouse. I have to enter a persons work time ( clock in and clock out times) as well as individual tasks start and stop times. This is incredibly easy for all shift other than the second since they usually start their shift on one day and end on another ( clock in at 1:30 pm and clock out at 12:30 am the next day).



In order for me to get the total minutes worked I have to enter the date and time so access understands the spacial time reference I am getting at.( clock in at 1:30 on 4/10/2019 and clock out at 12:30 am on 4/11/2019) This also effects the last task of the day because it usually has the same issue. (start the task on one day and Finnish on the next. )

Anyone have any tips to handle this other than having to type the date and time since this can get tedious and since it can take twice as long to enter second shift data other than any other shift.

[ranman256]

Date/Time should be in 1 field. THAT is how it can calculate elapsed:

[clockIn] = 1/1/19 11 pm
[clockOut] = 1/2/19 7 am

time worked = DateDiff("h", [clockIn], [clockOut])

[chriswrcg]

thats how i do it now. looking for a trick to speed things up if it exist. If not oh well.

[pbaldy]

If you just have times:

http://www.theaccessweb.com/datetime/date0004.htm

[Micron]

nice little trick pbaldy!

I gather the main complaint is all the date/time typing. There are quite a few time-clock type examples for Access.
Try searching on "ms access time clock application" and even use the "images" option - assuming you use Google. Maybe something out there will take away some of the drudgery.