Round Current Time (Time())

Topic

New Reply

This may be a simple fix, but I am trying to round the current time ,Time(), to the nearest 15 mins within a macro.

The macro contains Action = SetValue, Arguments={SIGN IN],Time()
The macro is being used on a form after a click on the Sign in Check box, the time is updated in a Sign In Text Box.

I have not used macros very much in the past and maybe using the wrong action.

Any help is appreciated.

Reply | Quote

Replies

Brandy,

See this thread.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

mround does not show as a Access Function when I try to update the expression.

Reply | Quote

Yes the link that Retired Geek gave you pointed to an Excel thread, and mround is an Excel function.

I was going to point you to a recent thread on this subject, but I realised that this thread was yours. So what are you asking here that is different to that thread. Do the suggestions given there not work?

In your previous thread I included a link to Allen Browne’s rounding page that had a function for rounding time.

Reply | Quote

I couldn’t get the first ones to work, but it worked with the int formula.

Reply | Quote

John,

Great link…thanks. 1 Thumbs up!

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Thanks..but it is Allen Browne that deserves the Thumbs Up!

Reply | Quote