floor function

[Guest]

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.

 

[Bob Phillips]

=FLOOR(A21,1/24)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks.....I got it working.

=FLOOR(A21,1/24)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)