Now that's a big help.

You get out of this group what you put in. If we can't understand what
you're asking for, we can't help you.

Regards,
Fred.

"springtimetigger" wrote in
message ...
job numbers

"Fred Smith" wrote:

What's in C6:S6?

Regards,
Fred.

"springtimetigger" wrote in
message ...
I am using this formula to add the hours that a tech has worked in a
day,
however I need it count by half hour intervals when I changed the 1 to
.5
it
counted 0.

=SUM(IF(ISTEXT(C6:S6),1,0))

Thanks in advance!