Hello Onin here

I was really looking for a time that will allow me to measure the time spent on a work meeting the following odd conditions:
1. Employee can submit a ticket and provide details anytime.
2. The work hours of many crosses over midnight.
3. Stop and start time within business days and work hours only.

I try using this but do not get the correct calculation across the said conditions.

=(NETWORKDAYS(StartDT,EndDT,Holidays)-1)*(StopTime-StartTime)+IF(NETWORKDAYS(EndDT,EndDT,Holidays),MEDIAN(MOD(EndDT,1),StopTime,StartTime),StopTime)-MEDIAN(NETWORKDAYS(StartDT,StartDT,Holidays)*MOD(StartDT,1),StopTime,StartTime)

Thank you!