Time keeping Errors

[TJ_IE]

Hello all

I have this userform that keeps track of parts going in and out

I have a couple of issues

one problem is that when it goes on to the next day it wil not account for a whole day passing

say it goes in at 4am and come out 4am the next day. it will not tell me 24 hours.

Another issue is the comparing of cycle times with actual times. I want it to tell me the amount of hours over or under the cycle times. (in order to get negative hours I had to use the 1904 system)


Any help is greatly appreciated


I have attached a file of what I have so far

[natefarm]

You probably need to combine the date/time values into a single column to do the math on them. You could still keep the time in a separate column if you wish, but instead of moving the date-in value to the date-in column, move date-in + time-in to the date-in column. You can keep it formatted as m/d/yy so it won't look any different than it does now, but when you subtract date-in from date-out, it will show the actual hours difference.

I also noticed a couple of problems with your code when I tried to run it. One is that nextrow was defined as a string. Needs to be a long. The other is that

Please Login or Register  to view this content.

needs to be

Please Login or Register  to view this content.

I didn't look much beyond that.

[TJ_IE]

My apologies for the late reply.



thank you that helped out by the way I appreciate it.