ok ill have a look at that (think ive got the formula worked out now.

whats the difference between [hh]:mm and hh:mm ? im guessing [hh] wil
accept negative values

--
Message posted from http://www.ExcelForum.com