Nick,

Simple subtraction will work. Excel stores dates internally as numbers.
When one of the cells involved in an arithmetic operation has a certain
format Excel often uses the same format for the output. You have two
options:

=B2-A2
and format the cell as general. Or,

=VALUE(B2-A2)

HTH
Kostis Vezerides


Nick wrote:
I've tried fornatting, to no avail.......I'm on Excel '97.

Cheers

Nick