View Single Post
  #1   Report Post  
AJG
 
Posts: n/a
Default Summing Time Data

Hi.
I have numerous schedules (one on each sheet). I also have a Summary sheet
in which I sum the information (linked) on each sheet.
I'm trying to do a SUM function to the time data, but I keep getting zero as
the result. However, if I manually add the data (Sheet1!A1+Sheet2!A1,etc.)
it works.
Again, the data is in time format "h:mm."
Is there anyone out there who knows why the SUM function won't work, but
manual addition will?

Thanks a lot.