How to calculate the difference in dates with timestamp in hours

[Anonymous]

Hi

I need to calculate the time difference between Open date and Resolved Date in hours.

If the Impact is High i need to find out how many tickets were resolved within 12 hrs. i.e Resolved date- Opened data <= 12 hrs.

Can somebody plz help me to calculation the difference in dates?

Attached is my base file

[squeakie_pig]

try the interval function

eg. Inteval(timestamp2 - timestamp1, 'h')

If I put the following in a text object:

='Daystart = ' & DayStart(today()) &chr(10)

&'ReloadTime = ' & ReloadTime()&chr(10)

&'Inteval = ' &interval(DayStart(today()) - ReloadTime(), 'h')

End up with an inteval of 18 hours (based on the times I had in a qvw I had open)

[m_woolf · Accepted solution]

If you don't need to report the time difference in hours, just count the no. of tickets:

12 hours = .5 day

if(Resolved date - Opened Date<=.5, .....

If you need to report the difference in hours:

Time Difference or Time in Human Readable Format

[Anonymous]

I used the interval function along with timestamp# given in the post and it resolved the issue.Thanks!!!