I'm trying to use the floor function in excel VBA using both date and time.
Is this possible?

For example round down 05/15/06 17:58 to 05/15/06 17:00

Thanks in advance. :)

=FLOOR(A21,1/24)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"srroduin" wrote in message
...
I'm trying to use the floor function in excel VBA using both date and
time.
Is this possible?

For example round down 05/15/06 17:58 to 05/15/06 17:00

Thanks in advance. :)

Thanks.....I got it working. :)

"Bob Phillips" wrote:

=FLOOR(A21,1/24)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"srroduin" wrote in message
...
I'm trying to use the floor function in excel VBA using both date and
time.
Is this possible?

For example round down 05/15/06 17:58 to 05/15/06 17:00

Thanks in advance. :)