My TimeDimension table has these fields:

TimeID

FullTime

Hour12

Hour24

Minute

Second

AMPMIndicator

I've taken a stab at creating a separate TimeSpanDimension table with the following fields:

TimeSpanID

TimeSpan1

TimeSpan2

TimeSpan3

The sample rowset might be:

TimeSpanID TimeSpan1 Timespan2 TimeSpan3

...

Nicely done...

This can be hugely useful, although for accuracy's sake i'd suggest renaming it the "Date Dimension", since it doesn't really have anything to do with Time... A Time dimension would...