View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Liesel
 
Posts: n/a
Default 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?