I am totally doing the happy dance right now.

Thank you!!!!

Steve and Lynn - Both of these are awesome... I'm a bit star-struck by you! 😉 I am a social work therapist by education, so I have been teaching...

I think this will work!

My times are currently in integer form, so I need to do some adjusting before I can run this.

Seriously thank you... It's actually...

Thanks, this is useful!

Oh wow, great questions!

-Yes, there is a SERVICE_THRU_DATE. The time spans midnight when that field is not null.

-No need for different time zones.

-The start...

Thanks for the reply! Maybe an example will help. I'm trying to find the overall staff minutes per day rather than the patient's minutes if you will...

STAFF, SERVICE_DATE, PATIENT,...