24 hour time slots from a specific time point

Question

Hi! &nbsp;Is there a formula to make 24 hour time slots from a specific time? For example, 3/3/25 @ 0810. The 1st 24 hour box would be (3/3/25 @ 0810 - 3/4/25 @ 0810), 2nd 24 hour box (3/4/25 @ 0810 - 3/5/25 @ 0810), etc. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Also, once those 24 hour prefilled dates and times are created for 15 days, is it possible to take a shreadsheet with dates and time entries and place them into the correlating 24 hour time slots from a specific time? For example, if an entry was dated and timed 3/3/25 @ 0935, and 3/4/25 @ 0700, both of those would fall into the 1st 24 hour box and so on. Thank you in advance for saving me hundreds of hours doing this by hand!

giuseppina · Answer

Sure!&nbsp;Yes, you can do this:Make your first time slot from 3/3/25 @ 08:10 to 3/4/25 @ 08:10, then just add 1 day each time to get the next 24-hour slot, repeating for 15 days.To place entries into the right slot, you can use a simple IF or IFS formula to check if each time falls &gt;= start time and &lt; end time for that slot, so it groups them correctly.Super doable in Excel — will save you tons of time.&nbsp;

mattburr · Answer

Hi MoojCould you upload a spreadsheet with the original data and what you would like it converted to?ThanksMatt

Forum Discussion

24 hour time slots from a specific time point

2 Replies

Resources