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

Community Questions

Create Custom Event Property for Working Hours in Mixpanel

Tim V.

·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?

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 😞