Here is a link to a site which gives excel formulas for working withtime and date variables. I have used some of the formulas in VBA andthey worked great.http://www.cpearson.com/excel/datearith.htm