rounding off time

  • Thread starter Thread starter Bre-x
  • Start date Start date
B

Bre-x

Hi,
I am working on a Time Clock app for the shop employees.

I need to now how to "round time"
Example

if the employee sing in between 10:00 AM to 10:30 AM his/her start time
will be 10:00
if between 10:31 AM to 10:59 AM the start time will be 10:30

Thanks for your help

Bre-x
 
never mind
dim mm as integer
Select Case Minute(Now())
Case 0 To 30
mm = 0
Case 31 To 59
mm = 30
End Select

hehehe
 
Back
Top