Can someone help with the following: I am trying to count the number of conversions in the same week a lead has been signed up in, however I would need a week start to start from Monday 13:30 specifically, due to accumulation of sign-ups over the weekend.
I have been able to set the week start to start from Tuesday, in the DATEDIFF function, but I am unable to set a specific time here.
Both of my fields (sign-up and conversion) have a time value.
Thanks in advance for any ideas!
Can you provide a sample workbook?