Thread: time sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default time sheets

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!