Create Custom Event Property for Working Hours in Mixpanel

·Oct 10, 2025 09:46 AM·

Is it possible to create a custom event property in Mixpanel on existing events that calculates if the time property is within working hours of 0800 1800 UK timezone?

3 comments

· Sorted by Oldest

Johannes K.

·

There are most certainly more elegant ways to do this(!), but just showing that this is possible with a custom event property. As proof here, I used this formula, which returns to outside if the hours are outside of 8 and 18 (adjust for your timezone).

IFS(
  (NUMBER(MID(STRING(@"""{"label":"Time","propertyDefaultType":"datetime","resourceType":"event","type":"datetime","value":"$time"}"""@),12,2))<8),"OUTSIDE",
  (NUMBER(MID(STRING(@"""{"label":"Time","propertyDefaultType":"datetime","resourceType":"event","type":"datetime","value":"$time"}"""@),12,2))>18),"OUTSIDE",
)

🙌1

Johannes K.
·
·
Tim V.
·
·
Thanks Johannes K. unfortunately this won't work within UK daylight savings or across different timezones/locales though 😞

Johannes K.

·

There are most certainly more elegant ways to do this(!), but just showing that this is possible with a custom event property. As proof here, I used this formula, which returns to outside if the hours are outside of 8 and 18 (adjust for your timezone).

IFS(
  (NUMBER(MID(STRING(@"""{"label":"Time","propertyDefaultType":"datetime","resourceType":"event","type":"datetime","value":"$time"}"""@),12,2))<8),"OUTSIDE",
  (NUMBER(MID(STRING(@"""{"label":"Time","propertyDefaultType":"datetime","resourceType":"event","type":"datetime","value":"$time"}"""@),12,2))>18),"OUTSIDE",
)

🙌1

Johannes K.
·
·
Tim V.
·
·
Thanks Johannes K. unfortunately this won't work within UK daylight savings or across different timezones/locales though 😞