Hi! I hope you can help me with this one.

I'm having a problem on how to extract the number of hours by subtracting field2 by field1 with a combination date & time format.

given two fields:

i.e.
field1 = 2000-05-15 02:17:22
field2 = 2000-05-14 23:24:20
---------------------
total time = 2h:53m:2s

I'm interested on how to extract the total time result and particularly the hours portion.

Thanks in advance