Splitting up a variable range of time into multiple cells

  Kiến thức lập trình

I need to split up a range of time from a variable input in excel, for example

Start End
11:00:00 13:00:00

I would like to have the input split up in segments of 30 minute intervals (input is only possible in 30 min intervals as well), so that I have the (time) values 11:00,11:30,12:00,12:30 and 13:00 all in different cells next to or below each other.
I was not able to find anything using the standard excel tools and since I have no experience with programming I can’t really use VBA either. Any help is appreciated 🙂

  • excel
  • time
  • split

New contributor

nocluewhatimdoing is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct. 

=SEQUENCE((B1-A1)/TIME(0,30,0)+1,1,A1,TIME(0,30,0))

Theme wordpress giá rẻ Theme wordpress giá rẻ Thiết kế website

LEAVE A COMMENT