Search results

Thank you!

So instead of having a date field and a time field I need the combo of both?

Thank you! I've always done time as numbers and this is a bit confusing. I figured out what is happening though. If the total time is over 24 hours it is resetting it to zero instead of totaling the time.

Thank you all for your help above. Thanks to you I finally got it to round time and calculate the daily total then break the time into categories. I can't get it to total the week on the form or total the category times as well as convert 1/2 an hour to .5. I was working on the Copy Of...

Yes military time. I assume I need to use the general time format as there are many calculations that need to be made including accruals that can be up to 500 hours. It needs to start with timein rounded to nearest quarter hour. TimeOut rounded to nearest quarter hour and lunch. Then timeout...

I currently have tables set up to track employee time. TimeIn, TimeOut and Lunch. Since we round time I set it up as a general number and use military time to calculate howver, obviously, this will leave room for error. Is there any way to enter it as a time and round it to the nearest...

Ok - I'll try that. Thanks so much!

This isn't working. :(

Good morning, I am working on a database for employee timecards. I have the following tables EMPLOYEES Name Address, etc TIIMECARDS TimeCard ID Employee ID TIMECODES TimeCodeID TimeCode TimeCodeDescription (sick,vacation,etc) TIME CARD DETAIL TImecard Detail ID Timecard ID Date TimeIn...