For working with times see Chip Pearson's site for formulas and info.
http://www.cpearson.com/excel/datetime.htm#AddingTimes
Gord Dibben Excel MVP
On Tue, 19 Apr 2005 16:35:02 -0700, mtw wrote:
How do I get the difference between to times without getting a "#VALUE!" error