thanks chris, i had just found the modulo in BOL...

i am trying to add a day into the equation after every 8 hours, is this just as simple?