Excel Formula for Data Reporting

Job ID: 39914141

Budget: ₹100 – ₹400 INR

I need an Excel formula to pull result from a list of time stamps(typically every 30 minutes for 24 hours) and plug result closest to 10am and 10 pm into calendar.