converting time as text in formula to get sum of cells
I have programmed a spreadsheet to accept daily hours entered in a1 and
summed in b1.... for 6 days. When I try to create a formula to accept total
sums of c1,f1,i1,l1 and o1. It will not do so for me. I either get a blank
cell or 0.00. I have changed that cell to be a custom of (h):mm:ss, however
it still will not total them for me.
|