Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Grouping by 15min increments
- Thread starter BIProf
- Start date
Assuming <DateTime> is the variable with the date/time you want to group, you could create a variable with the following formula:
=AsDate(FormatDate(<DateTime>, "yyyy-mm-dd HH:"
& FormatInteger(LowerInteger(AsInteger(FormatTime(<DateTime>, "mm")/15)*15, "00", "yyyy-mm-dd HH:mm"
I'm not sure of the names of the functions, since I use the spanish version. Note that 'AsInteger(FormatTime(<DateTime>, "mm")' is a kind of 'Minutes(<DateTime>)'.
The trick is in 'LowerInteger(<minutes>/15)*15', that returns 0 to range [0-14], 15 to range [15-29], etc.
=AsDate(FormatDate(<DateTime>, "yyyy-mm-dd HH:"
& FormatInteger(LowerInteger(AsInteger(FormatTime(<DateTime>, "mm")/15)*15, "00", "yyyy-mm-dd HH:mm"I'm not sure of the names of the functions, since I use the spanish version. Note that 'AsInteger(FormatTime(<DateTime>, "mm"
)' is a kind of 'Minutes(<DateTime>)'.The trick is in 'LowerInteger(<minutes>/15)*15', that returns 0 to range [0-14], 15 to range [15-29], etc.
- Status
Similar threads
- Locked
- Question
- Locked
- Question