B
bob
Hi,
Rounding time to the nearest 1/4 of an hour for employees punching in and
out. Ex.
Start time 07:00:00
Finish Time 15:06:00
Total Time 08:06:00
I would like it to round down to 08:00:00 and show into a field or if it was
past the half way point that it would show it as 08:15:00
This would be going into a control source properties box on a form.
here is the twist to can it be shown as 08:00:00, 08:25:00 and 08:75:00
These are al in a table as Date/Time
Once again thank you for the help
Rounding time to the nearest 1/4 of an hour for employees punching in and
out. Ex.
Start time 07:00:00
Finish Time 15:06:00
Total Time 08:06:00
I would like it to round down to 08:00:00 and show into a field or if it was
past the half way point that it would show it as 08:15:00
This would be going into a control source properties box on a form.
here is the twist to can it be shown as 08:00:00, 08:25:00 and 08:75:00
These are al in a table as Date/Time
Once again thank you for the help