How to count working hours taken(8 hrs a day) time from Created and Resolved date ?

[shrutithakur297]

Hi,

It will be really helpful if anyone of you can help me. I am struggling to get it done from days.

1. I need to find working hours taken taking 8 hrs a day

2. Add new column having value Success and Breach on Severity field as mentioned below :

Created	Resolved	Custom field (Severity)	Interval (Timestamp#(Resolved,'DD/MMM/YY hh:mm tt') - Timestamp#(Created,'DD/MMM/YY hh:mm tt'), 'h')				TIME RANGE
12/Mar/18 3:22 PM	12/Mar/18 3:40 PM	S1-Critical	0	1	S1-Critical	1 HR	SUCCESS
12/Apr/18 2:19 PM	12/Apr/18 2:36 PM	S3-Moderate	0	2	S2-Serious	4HR	SUCCESS
11/May/18 11:19 AM	11/May/18 11:36 AM	S3-Moderate	0	3	S3-Moderate	16 HR	SUCCESS
18/Apr/18 4:26 PM	18/Apr/18 4:41 PM	S4-Tolerable	0	4	S4-Tolerable	16 HR	SUCCESS
13/Mar/18 12:32 PM	13/Mar/18 12:46 PM	S1-Critical	0	5	BLANK	BLANK	BREACH
25/Apr/18 9:34 AM	25/Apr/18 9:45 AM	S3-Moderate	0	6		>16 HR	BREACH
28/Mar/18 4:45 PM	28/Mar/18 8:13 PM	S3-Moderate	3		**WORKING HOURS MEANS 9-5 PM 8 HRS A DAY

[krishna_2644]

Ye haath muje dede thakurr...haha..just kidding..

Can you please explain a bit in detail?

1. I need to find working hours taken taking 8 hrs a day - So you want to populate 8hrs for each row in a seperate column?

2. Add new column having value Success and Breach on Severity field as mentioned below : - need more clarity on this? please elaborate.

[eduardo_dimperio]

Hi,

1 -But how proceed if you get more than 8 hours a day or if you have less then 8 hours but out range (9-5pm)?

2- How works that definition of Success and Breach?

[zebhashmi]

if([Custom field] = 'S1-Critical' AND Interval (Timestamp#(Resolved,'DD/MMM/YY hh:mm tt') - Timestamp#(Created,'DD/MMM/YY hh:mm tt'), 'h')<1, 'SUCESS',if([Custom field] = 'S2-Serious' AND Interval (Timestamp#(Resolved,'DD/MMM/YY hh:mm tt') - Timestamp#(Created,'DD/MMM/YY hh:mm tt'), 'h')<4, 'SUCESS', and so on..

you can use Match and pick for that as well