adding numbers

  • Thread starter Thread starter greg
  • Start date Start date
G

greg

Hello,
I have a spreadsheet where I am storing hours.
So 1h or 5h, etc...
Is there a way I can select a bunch of cells. and add these numbers.
Even though there is "h" in the cell?
thanks
 
SUM works just as well on time, just format the result cell as [h]:mm if it
might exceed 24 hours.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
You could use an array formula like this:

=SUM(VALUE(SUBSTITUTE(A1:A10,"h","")))

Array formulas are entered by pressing Ctrl-Shift-Enter. If you press just
Enter it will not work.

--
Jim
| Hello,
| I have a spreadsheet where I am storing hours.
| So 1h or 5h, etc...
| Is there a way I can select a bunch of cells. and add these numbers.
| Even though there is "h" in the cell?
| thanks
|
|
 
Back
Top