time sheets
On Nov 5, 2:24*pm, springtimetigger
wrote:
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!
I think you want to make that a 2, not .5. And don't forget to CSE
enter it since it is an array.
|