how to give less than 18:00:00 hours??

[#1]

Hi ,

I have  a date field called closed date where i need to calculate how many calls closed till 6:00:00p.m.

can anyone help me on this ??? as i m not able to give <= 6:00:00. I m getting calls after 6p.m. also.

My date is in timestamp format

close date

3/26/2013 3:12:10 PM

3/27/2013 12:25:38 PM

3/27/2013 1:13:28 PM

3/27/2013 1:34:56 PM

3/27/2013 8:51:26 PM

3/27/2013 8:57:42 PM

3/27/2013 9:13:51 PM

3/30/2013 10:40:32 AM

3/30/2013 10:51:17 AM

[er_mohit]

See the attached file

[#3]

try this

=count(if(num(Time(Time#('06:00:00 PM','hh:mm:ss TT'),'hh:mm:ss TT')) > num(Time(Time#([close date],'MM/DD/YYYY hh:mm:ss TT'),'hh:mm:ss TT')),Time(Time#([close date],'MM/DD/YYYY hh:mm:ss TT'),'hh:mm:ss TT')))

[mseeck75]

Hi,

an other approach is to use the InDayToTime and DayEnd functions (see also help).

For example you can try:

count(if(InDayToTime([close date],DayEnd([close date],0,0.75),0),1,0))

BR

Matthias