Sean Lange (3/25/2013)

---

Since you are trying to record the amount of TIME something took why not use the TIME datatype?

declare @Time time = '09:26'

select @Time

Now you have stored only the amount of time and you can still query it very easily.