One of the new features of SQL Server 2005 is User Defined Types. A user defined type is a new scalar type added to the SQL Server type system and is implemented using .Net. A sample of a user defined type for time durations and an article that explains the basics of creating user defined types is at:

http://www.sqlservicebroker.com/samples/duration.zip