Thread
:
time sheets
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
springtimetigger
external usenet poster
Posts: 7
time sheets
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!
Reply With Quote
springtimetigger
View Public Profile
Find all posts by springtimetigger