ExcelBanter - floor function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - floor function (https://www.excelbanter.com/excel-worksheet-functions/88431-floor-function.html)

srroduin

floor function

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 function

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

srroduin

floor function

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

All times are GMT +1. The time now is 12:17 PM.