Time field calculation

[jnthpn]

I'm editing this company's "time card" application, I need to "Round" the minutes of this field to every quater, eg: if this employee start time of the day is: 09:07, I need it automatically turn it to 09:15; if it's 09:03 then I need it turn to 09:00. Is there any way I can do it?

Thanks,

[BobWeaver]

Round(YourTimeField/(15*60),0)*(15*60)

BTW, 9:07 would normally round down to 9:00. 9:08 would round up to 9:15. Is this intentional? I worked on a timecard system once, and the owner didn't want the times to round down at all, because he wanted to keep track of who arrived 5 minutes late all the time.

[ November 08, 2001: Message edited by: BobWeaver ]