ExcelBanter - is there a formula for rounding down time to nearest 1/2 hr

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

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

- - is there a formula for rounding down time to nearest 1/2 hr (https://www.excelbanter.com/excel-worksheet-functions/197515-there-formula-rounding-down-time-nearest-1-2-hr.html)

Rosemary

is there a formula for rounding down time to nearest 1/2 hr

Infinitogool

is there a formula for rounding down time to nearest 1/2 hr

Hi Rosemary
=ROUND(A1*24*2,0)/48

Regards,
Pedro J.

David Biddulph[_2_]

is there a formula for rounding down time to nearest 1/2 hr

=FLOOR(A2,1/48)
--
David Biddulph

"Rosemary" wrote in message
...

All times are GMT +1. The time now is 07:43 AM.