Thread: Timein-Timeout
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Stewart Jim Stewart is offline
external usenet poster
 
Posts: 1
Default Timein-Timeout

I am making a time-in and timeout sheet. If an employee is over 7
minutes late, he gets docked 15 minutes, 22 minutes late = 30 minutes,
etc. In other words, 7 minutes past the quarter hours jumps to the next
quarter. How can I make this happen when the employee clicks a button
that returns the time(Computer Time).
And is this possible using VBA code.
Thanks for any replies.
Jim