Do the cell have data like:
A) 10:30 PM
or
B) 9/1/2008 3:30 PM

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"DavidT" wrote in message
...
EXCEL 2003- How can I modify
"=IF((OR(C10="",B7="")),0,IF((C10<B7),((C10-B7)*24)+24,(C10-B7)*24))" to
add
up total hours over multiple days with a start time in one cell and end
time
in another cell. And how do I link those cells to a date.