Need to calculate business hours

[#1]

Business Hour = 9.30 AM-6PM

For calls logged after 6 PM, it should fall to next day 9.30 AM. ie, A call created at  5/26/2014 7 PM, then it should be displayed as 5/27/2014 9.30 AM  static

Any call logged after 6 PM should be considerd as next day call with 9.30 AM as default time

timestamp(if( WeekDay(Call_Created_Date)<>'Sat' and Hour(Call_Created_Date)>18,
( DayStart(Call_Created_Date+1) ) as BusinessDay

[jagan]

HI,

Try like this

=TimeStamp(If(Hour(Call_Created_Date) > 18, Floor(Call_Created_Date) + 1 + (570/(1440)) ))

570/1440 - will give you the 9:30 AM.

Regards,

Jagan.

[#3]

Hi Jagan Mohan,

Can you tell me how to write 10 AM??

570/1440 will give me 9.30. what will give me 10 am??

Regards,

Shamly P T

Program Transformation Office

• Mobile: +91 - 8088266881

• Email: shamly.t95@wipro.com<mailto:shamly.t95@wipro.com>

“Whatever the mind can conceive and believe,it can achieve”

[ThornOfCrowns]

Try 600/1440

[jagan]

Hi,

For 10 AM use 600/1440.

Hope this helps you.

Regards,

jagan.

[#6]

Hi Jagan Mohan,

Sorry to disturb. 1 help required.

1)Calls logged after 18 hrs, they have time to close the call till next day morning 10 AM.

a) Calls logged after 18 hrs (19 hrs) and closed at midnight 24 hrs is also achieved

b) Calls logged after 18 hrs (19 hrs) and closed at next day morning 9.30 is also achieved

c) Calls logged at 1 AM and closed at 9.30 Am is also achieved

c) Calls logged after 18 hrs (19 hrs) and closed at next day morning 10. 30 is NOT Achieved

e) Calls logged at 9.30 Am and Closed at 10.30 Am is also NOT Acheived

2) Calls logged between 10 am and 18 hrs, then we will check the difference of logged time and closed time.

a) Interval(Logged time- closed time,’MM’)< 180, then this is achieved, else it is NOT achieved

The expression I wrote is:-

=if( WeekDay(Logged Date Time)<>'Sat' and hour(Logged Date Time)>’10:00:00’ and hour(Logged Date Time)<< '18 hrs' and Less_Than_180_Mints_Flag='YES' ,'YES',

if( WeekDay(Logged Date Time)<>'Sat' and Hour(Logged Date Time)>='18:00:00' and hour(Closed Date Time)<< '24 hrs', 'YES',

if( WeekDay(Logged Date Time)<>'Sat' and Hour(Logged Date Time)>='00:00:00' and hour(Closed Date Time)<< '10 hrs', 'YES',

if( WeekDay(Logged Date Time)<>'Sat' and Hour(Logged Date Time)>='18:00:00' and Hour(Closed Date Time)<<'10 hrs', 'YES',

'NO'))))

Is This Correct???? Anything to add or delete??

Regards,

Shamly P T