Splitting up a variable range of time into multiple cells
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 :)
Solution
=SEQUENCE((B2-A2)/TIME(0,30,0)+1,1,A2,TIME(0,30,0))
- Need help to extract this XML node - Excel connection strings in Python
- Shift the range up after clear contents
- Enter Cell Formula using VBA
- Content is out of order when using Excel VBA to create a Word document
- Trouble with Vlookup on power queries?
- excel - hyperlink to sheet based on cell value
- Accessing a Variant/Object/JScriptTypeInfo property in VBA
- Move data to another table based on array value
- Partial exists in dictionary
- Name on Envelope
- Sorting data algorithm 900000 rows of data
- Expression.Error: We cannot apply operator & to types Number and Number
- Importing/scraping an website into excel
- Scraping Morningstar web page
- How do I get my For Next loop to actually loop
- Figuring out the number corresponding to a letter of the alphabet?
- how to select worksheet name from cell
- Npoi Round Formula
- How to get the sheet name from Application.Caller?
- How to declare variable by using for-next loop
- Apache POI Excel - how to configure columns to be expanded?
- How To Copy/Cut Row of Data Based on TRUE/FALSE Condition
- Workbook "Calculation Options" stays in Manual no matter the operation (open, save, close) being performed unless approved user hits Calculate
- Excel automate dynamic number of row generation from another set of data
- How to put sum of dataframe column in certain cell of excel sheet?
- Remove all special characters except space
- Excel is stripping leading 0's from CSV files
- Excel Button for a par sheet
- Remove border between Excel and PPT for a copy and paste VBA
- List of data.frame's to individual excel worksheets - R