formulas using date/time formats returning #value
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?
|