Whoops... I stand corrected. Thanks, Bob. I had tried calling it using
Application.WorksheetFunction and saw it's not available there. I guess
that's because it's already available as a native VBA function. Doesn't
affect the code I provided to Nils - it should work fine as written.

Hutch

"Bob Phillips" wrote:


"Tom Hutchins" wrote in message
...
Converting the times to a minutes integer is tricky. The best way I have
found is to use the Excel MINUTE function, which is not readily available
to
VBA.

msgbox minute(now)