# Need help with a formula

Hi Friends,

I need a help with the below listed formula

I have

1. Count of Incidents

2. I have Incident Closed date time ( eg: 11/1/2010 11:01:10 AM)

I need to find out

1. All Incidents that are closed <= 1 hrs
2. All Incidents that are closed > 1 hr
3. All incidents closed in > 1 day
4. All incidents closed in > 4 days

please guide me in creating the formula for the above.

Sam

sam4u (BOB member since 2008-01-09)

Hi,

Do you have something like â€śIncident Opened date timeâ€ť? How else would you calculate how many hours/days it took to close an incident?

Marek Chladny (BOB member since 2003-11-27)

Marek,

Yes I have incident open date time with me.

Sam

sam4u (BOB member since 2008-01-09)

Then take Closed Date Time and Open Date Time, calculate the difference between them and then use IF() statements to create â€śbucketsâ€ť - â€ś<= 1 hrsâ€ť, â€ś> 1 hrâ€ť, â€ś> 1 dayâ€ť and â€ś> 4 daysâ€ť. Then use it in a report along with the â€śCount of Incidentsâ€ť measure.

Marek Chladny (BOB member since 2003-11-27)

Marke,

Then can you please help me with the formula from where I can get the difference between dates in HH:MM:SS format.

Thanks,
Anil

sam4u (BOB member since 2008-01-09)

Marek Chladny (BOB member since 2003-11-27)

Wowwwwwâ€¦

Marek.