Forum Discussion
24 hour time slots from a specific time point
Hi! 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...
Sure!
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 >= start time and < end time for that slot, so it groups them correctly.
Super doable in Excel — will save you tons of time.