Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Calculating time between successful data transmissions | Excel Discussion (Misc queries) | |||
Split combined date time data | Excel Discussion (Misc queries) | |||
Split combined date time data | Excel Discussion (Misc queries) | |||
Split combined date time data | Excel Discussion (Misc queries) |