TroubleMaker
New Member
- Joined
- May 11, 2002
- Messages
- 12
Hey All,
Here is my next time issue. I am trying to add a list on hh:mm:ss in a column to get a total time. I have my total cell formatted for [h]:mm:ss and the formula of "=TIMEVALUE(O2:O38)" and I am getting #VALUE in the cell where the total is displayed. If I just try to add these cells in the column I get "00:00:00". However if I go in and type "=(O2+O3+O4+etc...)" they start adding the time in the cell. Can you help me out please?
Here is my next time issue. I am trying to add a list on hh:mm:ss in a column to get a total time. I have my total cell formatted for [h]:mm:ss and the formula of "=TIMEVALUE(O2:O38)" and I am getting #VALUE in the cell where the total is displayed. If I just try to add these cells in the column I get "00:00:00". However if I go in and type "=(O2+O3+O4+etc...)" they start adding the time in the cell. Can you help me out please?