Forum Discussion
Solved
Creating 15 Minute intervals from Date and Time Column
1. I have a column named,"STATS_DATE" which contains dates and time
2. Made a new column named, "Date" which contains only date from STATS_DATE
3. Made a new column named, "Time" which contains only time from STATS_DATE
4. Made a new column named, "Minutes"
Minutes = DATEDIFF(DATE(1899,12,30),Table[Time],MINUTE)
5. Made a new column named, "15Min_Data"
15Min_Data = INT(DATEDIFF(DATE(1899,12,30),Table[Time],MINUTE) / 15)
How do I convert it into intervals amitchandak ?
How do I convert it into intervals amitchandak ?
Try formatting this as Time data type:
15Min_Data = ROUNDDOWN ( 'Table'[Time] * 24 * 60 / 15, 0 ) / ( 24 * 60 / 15 )You can just use 96 instead of 24 * 60 / 15 since there are 96 fifteen-minute intervals in one day.
9 Replies
What is the end result that you want? What should the column look like?
The end result could be the start of the 15 minute interval like so
12:00 AM
12:15 AM
12:30 AMTry formatting this as Time data type:
15Min_Data = ROUNDDOWN ( 'Table'[Time] * 24 * 60 / 15, 0 ) / ( 24 * 60 / 15 )You can just use 96 instead of 24 * 60 / 15 since there are 96 fifteen-minute intervals in one day.
