m.dunster (10/30/2013)

---

Hi,

Wondering if anyone has an elegant solution to finding out how much time has elapsed for a specific hour.

declare @t as table (ptr int identity, START time, ENDD time)

insert into @t (START, ENDD)

SELECT '09:30', '10:30'

union all

SELECT '10:00', '11:00'

union all

SELECT '10:30', '11:30'

Taking the example table above, I am looking to output the amount of time elapsed for each hour block. So:

09 - 0.5

10 - 2

11 - 0.5

I can think of complicated and ugly ways using cursors and many lines of code, but I thought someone might have a more user friendly solution!

Many thanks for your time.

Matt