time sheets
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!
|