hi,
I am having datetime,dayofweak,start time,end time i need to find the count so that in a daysofweak from time start to end how many values are there and i used the following formula.
=COUNTIFS(E:E,"Sunday",F:F,">="&H2,F:F,"<="&I2)
Here for sunday ,from 00:00:00 to 00:59:59 i have found value with this formula ,now what i need is the date should be distinct for example now the date is duplicate for starttime to endtime but now if i got one date for a time stamp then i should not be counting that date again.
thanks
- Moved by Lanlan HuangMicrosoft contingent staff 4 hours 19 minutes ago