what is the formula for times for spreadsheets?

0 ⤊

what is the formula for times for spreadsheets?

2007-02-22 21:59:42 · 5 answers · asked by Anonymous in Science & Mathematics ➔ Mathematics

5 answers

=Sum(B2*C11)

2007-02-22 22:02:04 · answer #1 · answered by janetlouise24 4 · 0⤊ 0⤋

If you mean time of day, just enter the time in HH:MM or HH:MM:SS format, and Excel should recognize it. The Format/cells menu will allow you to change the display (military time, am/pm, etc.).

2007-02-22 23:22:59 · answer #2 · answered by Anonymous · 0⤊ 0⤋

If you are referring to the MULTIPLICATION sign, - then the ANSWER is * - the STAR, - achieved, by holding down "SHIFT", and depressing the "8" key!

2007-02-22 22:07:41 · answer #3 · answered by Spike 6 · 0⤊ 0⤋

you don't need the sum
quickest way is just = cell*cell

2007-02-22 22:06:30 · answer #4 · answered by pdgr2000 1 · 0⤊ 0⤋

=sum(_*_)

2007-02-22 22:03:46 · answer #5 · answered by Anonymous · 0⤊ 0⤋