INSERT INTO timecrunch.dbo.intervals (IntervalID, Duration)
SELECT ixInterval, DATEDIFF(hour, dtStart, dtEnd) FROM fogbugz.dbo.TimeInterval
WHERE dtEnd is not NULL

DATEDIFF(second, dtStart, dtEnd) / (3600.0)

INSERT INTO timecrunch.dbo.intervals (IntervalID, Duration)
SELECT
  ixInterval,
  DATEDIFF(mi, dtStart, dtEnd) / 60.0
FROM
  fogbugz.dbo.TimeInterval
WHERE
  dtEnd is not NULL