If you put your data into two columns, you're life will become lots easier.

And if you have your data already entered, maybe you can use Data|Text to
columns to separate it into those two columns.

Choose delimited by space.

Then you can just sum that second column and divide by 8.

But you could use a formula like:

=SUMPRODUCT(--MID(A1:A5,FIND(" ",A1:A5)+1,255))/8
(adjust the range to match your data (in both spots!).)

But you'll find excel lots easier to work with if you separate different fields
into different columns.

Kevin wrote:

I am trying to build a spreadsheet so I can track my times at work. I am
having trouble trying to create a formula for 1 cell that will sum all the
days of the month, and add a 1 for every 8 hours of standby time example:
01/02/05 4 hours of standby, 01/03/05 2 hours of standby, 01/04/05 8 hours of
standby, 01/05/05 2 hours of standby, with the total being 16 I want that
cell to calculate too 2.
Thanks for any help you can provide!!
Kevin.

--

Dave Peterson