I'd like to enter a start time in a cell, e.g. 7:13 AM and have Excel show it as 7:00, BUT, if I entered 7:16 have it show 7:30. I would need a similar response if I entered 7:44 AM (it should show 7:30) and if I entered 7:46, it should show 8:00.
How do I format that, or which formula should I use?