floor function

S

srroduin

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. :)
 
B

Bob Phillips

=FLOOR(A21,1/24)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top