Calculation of time difference

Juergen1101

Hi!
How can I calculate the difference between two times in hours?

For example: Time 1 := 12:30:00T, Time 2 := 14:00:00T. The result should be 1.5

Thanks
Jürgen

J

if you do the following:

Duration := "Time 2" - "Time 1"

Duration is the timespan in milliseconds. Just calculate that back to hours yourself.

Hours := ((Duration / 1000)/60)/60;

Duration is of datatype duration
Hours is of datatype decimal

Hope this solves your quest.

Juergen1101

Thanks, it works fine!!