Does anyone know of sql that will sum time of overlapping dates.
eg.
open 01-jan-2003 10:30
close 02-jan-2003 22:30
open 02-jan-2003 11:30
close 03-jan-2003 10:30
Total of 48 hrs. Not 59 hrs.
|
Results 1 to 6 of 6
Threaded View
|
Click Here to Expand Forum to Full Width |
Reply With Quote