Search results

I am trying to use the =Sum(txtHours) on a form footer. All I get is error, what am I doing wrong?

Thank you all for helping a beginner in date/time calculations, i am marking this solved for now until further testing.

Thank you, I will check into it, but I have solved my issue using minute() to test for 0,15,30, & 45. So far so good. thanks

I am not sure what you are saying here Gasman, If my employee is late by 1 minute then they are considered late. so... 5:30:01 still needs to round to 5:30 but 5:31:00 needs to round up to 5:45:00 The similar situation applies when they are punching out.

The problem is this: I do not want to round up if the employee punches in at 5:30:01, that is still considered punching in at 5:30, it is only when they punch in at 5:31:00 or greater that I want to round up.

I found another solution to my rounding problem. TimeSerial(Hour([mytime]),(Minute([mytime])\15)*15,0) Can anyone tell me how to change this to round up?

This is for calculating payroll times and if I don't strip the seconds when using your rounding up function - 5:30:01 becomes 5:45:00 But your functions still Rounds 5:30 up to 5:45 - am i doing something wrong? Public Function RoundUpToNearestDate(d1 As Date, Optional RoundTo As Date = 1) As...

No errors, just a newb being a newb. :)

I copied and pasted then realized the code wasn’t complete. Works perfect. Now I have to figure out how to get rid of the seconds in my data so they 5:30 doesn’t become 5:45. Any ideas? My form that enters the original data captures the date and time, then the form that takes that value and...

RoundUpToNearestDate not working, I used the same arguments when test the first function. Am I doing something wrong? Getting Runtime error '6' Overflow Here's my code: Private Sub Form_Current() If IsNull(txtAdjTimeIn) Then Dim T1 As Date T1 = TimeSerial(0, 15, 0)...

Thanks, I am going to do some testing, how does this handle a date like 1/6/2021 11:59 with rounding up to the nearest 15 minutes? Will it give me 1/7/2021 12:00? Will it

Ok, Sorry, I was brain dead, I've got the function working does anyone know how to make it round only up or only down?

Ok so what I did was put the code in the query field for the recordsource and it works, but I can't seem to format the new date field. How would I go about this?

I have copied the following code from another thread, post #4, the thread is located here: https://www.access-programmers.co.uk/forums/threads/roundup-or-down-to-the-nearest-half-is-it-possible.237264/ It is not working , please help Public Function RoundTime(varTime As Variant, Optional ByVal...

Going live for testing with all employees tomorrow! I want to give a big shout out to the forum and all the great help I keep receiving from this forum! Pbaldy Plog Gasman CJ_London And I won’t forget are arnelp from other posts I’ve made, if I am forgetting anyone it is not because I do not...

One company policy is that the work week starts on Monday at 12:00 am and it ends on Sunday At 11:59, So I could have an employee that works Sunday from 9pm to Monday at 8am and that work would be on the tart time's work week as far as O/T is concerned. So their last day as far as the pay period...

my only concern with shifts is that an employee could punch in on one shift and then when they punch out it would be on another shift. I am thinking that I can use the punc in time to determine which shift the record goes with. Does that sound correct?

Love the Date functions, Thanks One question - How do I change the first day of the week to Monday?

I don't need shifts we only run one shift. And I can't see a reason i would ever need Work Order punches and time clock punches on the same report. You say it is not wrong so is it ok or better to do it in one table. Then do I create different kinds of punches in one table, one field for...

Ok so now i am creating separate tables for calculating payroll hours. I need to be able to clock-in monday -sunday (Monday is our first day of the week. My form needs a period ending date automatically entered based on Sunday for the current week. My employees will choose from a option frame...