
August 20th, 2003, 08:35 AM
|
|
Registered User
|
|
Join Date: Apr 2003
Location: Antwerp, Belgium
Posts: 24
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Access: need to round Time()
Hi,
I want to give a standard value to a part of my form.
At the moment the standard value is: =Time() which works fine but I need to round this in parts of 15 minutes
eg: 9.10 should become 9.15
9.05 should become 9.00 (or 9.15 if its only possible to round up)
10.27 should become 10.30
and so on.....
which expression do i need for this?
Greetzzzz
|