Forum Discussion
Solved
Add 30m to date/time using Power Query.
Hello, I have a column with date/time stamps where I need the time stamps to be in 30 min increments, so instead of 03/01/2023 12:00:00 AM listed over 48 times I need row two to say 03/01/2023 1...
LHub Add an Index column starting at 0 and then a custom column:
= Table.AddColumn(#"Added Index", "Custom", each [Column1] + #duration(0,0,30,0) * [Index])
Thank you! It was skipping every other day so I added a Modulo column up to 48 and that worked! 🎉