Hi!

Test the dates/times to make sure they are in fact real Excel dates/times.

If you have these cell values:

A1 = 5/26/2006 5:33:00 AM
B1 = 5/26/2006 5:26:00 AM

Try this test:

=ISNUMBER(A1)
=ISNUMBER(B1)

If both cells are real Excel dates/times then those Isnumber formulas will
return TRUE and a simple subtraction formula should work without returning
an error.

Biff

"Liesel" wrote in message
...
Hi

Am dumping data out of an application - raw data appears as
5/26/2006 5:33:00 AM (i.e. mm/dd/yyyy hh:mm:ss AM/PM) - format all the
cells in custom format to this. However when I go to calculate the
difference between two times (elapsed time) returns #VALUE.
5/26/2006 5:33:00 AM less 5/26/2006 5:26:00 AM s/b 07:00

It's probably something very simple - can someone help please?