Biff's idea about changing the format is on the mark.

Since STBY and HOT hours are in their own row why bother with the letters in
those rows?

I would insert one row above current row 10 and split the OT/COM hours into
seperate rows for OT and COM

Dispense with the letters in those rows also.


Gord

On Sat, 23 Feb 2008 05:39:00 -0800, Wayne
wrote:

Okay I have removed the 2 functions and will place the file on savefile.com
(waiting on the activation link) I also place the file here,
http://www.thez4.com/FileShare/book2.xls

Once you open the spreadsheet you will see the top area is the timesheet
area. I just spoke with the mgr who is going to be using the timesheet and
she explained that the letters indicate the type of OT IE: C=Comp Time :
O=Straight OT : S=Stby etc. Column R is the totals column. Rows 9,10 & 11
Columns C:I & K:Q will be the only rows where text will ever appear in a cell
and need to be totaled. Row 6 will just have straight hours and therefore
doesn’t need any modification. They should have presented this info in the
first place and

T.Valko recommended changing the format of the spreadsheet, that was the
first question I asked but they have been using this format for some time and
don’t want to change it.

I wish to extend my thanks for everyone who has offered to help me.

PS it’s been like ten minutes and I still don’t have the email so I will
post the link once I get it.

Wayne




"Gord Dibben" wrote:

Wayne

You can post the workbook at one of the hosting sites below.

http://www.freefilehosting.net/
http://savefile.com/

When you have uploaded to that site, post the URL so we could download.


Gord Dibben MS Excel MVP

On Fri, 22 Feb 2008 19:54:01 -0800, Wayne
wrote:

Ron,

Can I post files here? I can post the spread sheet that would show exactly
what I am attempting to do. I am using MS Office 2007 Pro.

Thanks

"Ron Rosenfeld" wrote:

On Fri, 22 Feb 2008 19:09:00 -0800, Wayne
wrote:

Okay Thanks to both of you, unfortunately I can’t seem to get either option
to work. I am weak in this area of Excel. I get the function entered okay,
just keep getting reference errors. For Gords I get a #VALUE! Error if I
attempt to reference more than one cell. In my example I should have stated
that this is a time sheet therefore I need to sum up K1 to K9. For Rons in
the same case I get a Function not valid error.

In your original post you indicated the string was in "a" cell, implying one
cell. That is how my function is designed to work. It is NOT designed to work
over a multicell reference. But it will work not only on the example you gave,
but also on examples like 14.63CDE + 0.478ABC (again all in one cell).

If you have mixed-text and numbers in K1:K9, you should be able to enter my
function in an adjacent column in the form =EvalNums(K1) and fill down to K9;
then SUM that column.

Or you could provide more specific information about your data.

Also, I've not seen a "Function not Valid" error. Where do you see that? What
version of Excel?

In mine, when I select multiple cells, I get a #VALUE! error in the worksheet
cell with the formula.
--ron