Integer in format date

[warrentk80]

Hello to all

I have a calculated field as the ratio of total ticket and the total time taken for resolution.

the result is an integer that should express in hours to have a mean time to resolution.

would know someone help me out

For example, the ratio between the total time of taking charge and the total ticket the result is 1.3

tell me someone would know how to express this value in hours?

thanks

Andrea

[MK_QSL]

What is your expression to get this ratio?

[CELAMBARASAN]

May be your formula will be something like this

Num(Text(Interval(TotalTime, 'h'))) / TotalTicket

TotalTime is total time of taking charge - Difference between 2 datetime.