Calculate with Timestamp field

[TomBond77]

Hi experts

I would like to calculate the difference in hours between these two fields.

Can you help me on this?

Many thanks!

[NiTo · Accepted solution]

Hi, Try using this

Interval(Starttime - FinishTime, 'hh:mm:ss') as Diff

Hope it will work

[TomBond77]

can we transform the result into a field like:

48:00 --> 48.0

or

2:30 -> 2.5 ?

Thanks

[NiTo]

So instead of 1:30:00 , u want the result to come up as 1:30? Am, I correct?

[TomBond77 · Accepted solution]

No, for 1:30:00 I would like to get 1.5. 

[NiTo · Accepted solution]

Try

Interval#('1:30:00', 'hh:mm:ss') * 24 = 1.5

[TomBond77]

how can you add 2 hours which changes the HH but also the date if necessary?