Convert hh:mm:ss to hours

[stekol61]

Hi!

I want to convert the timestamps below to hours.

I tried to use the Hour() expression but i doesn't seem to work when hour part is higher than 24h.

Any idea how to solve this?

Ticket ID	response_time_bh
OP-000001700301	102:01:45
OP-000001697522	03:19:41
OP-000001689558	05:03:43
OP-000001665107	278:34:00
OP-000001655877	302:03:55
OP-000001653706	296:02:07

[Vegar]

Try this expression:

=interval(interval#([response_time_bh], 'hh:mm:ss'),'h')

[stekol61]

Hi!

I added the expression (New) to my table but the result doesn't seems to be correct.

The 'response_time_bh' is calculated in the load script. I don't know if this matters?

Ticket ID	response_time_bh	New
OP-000001700301	102:01:45	4,25
OP-000001697522	03:19:41	0,14
OP-000001689558	05:03:43	0,21
OP-000001665107	294:53:39	12,29
OP-000001655877	318:23:34	13,27
OP-000001653706	312:21:46	13,02
OP-000001653705	314:22:29	13,10

[Vegar · Accepted solution]

the New expression is showing the underlying numeric value of the interval. 102:01:45 is 4,25 days.

To format the New back to no of hours do this

=interval(New, 'h')