I have a database that shows StartTime and EndTime for video conferences. Since we are a global company our meetings can (for example) start at 06/30/2010 11:15PM Eastern and end at 07/01/2010 1:30AM Eastern. I need to be able to report on utilization per day...so in the above example, I need to to show:
and also be able to include these minutes when geting MTD stats
Should you need it the data looks like this - Table name is ScheduledCall
StartTime 2010-06-30 23:15:00.000
EndTime 2010-07-01 01:30:00.000
I will be utilizing the stats in a dashboard system.
Let me know if you need further information