Calculate hours between time intervals

[qw_johan]

Hi

I need to calculate how many hours there are between a persons work shifts in a

schedule, his "resting time" so to speak.

My table is simple: id_number, timestamp_from, timestamp_to.

My code so far...

LOAD

     id_number,

     timestamp_from,

     timestamp_to,

     Interval(Previous(timestamp_to) - timestamp_from, 'hh:mm') as rest_time

FROM ....

Problem...

The resulting hours in rest_time is a negative number...how to make it into a positive number?

Thanks

[kumarnatarajan]

Hi,

Use Fabs() function for positive.

But check your timestamp fields format Interval() function will return correct hours.

[jagan · Accepted solution]

Hi,

Just change from and to column positions in Load script..

LOAD

     id_number,

     timestamp_from,

     timestamp_to,

     Interval(timestamp_from - Previous(timestamp_to) , 'hh:mm') as rest_time

FROM ....

Regards,

Jagan.

[#4]

fabs(x)

The absolute value of x. The result is a positive number.

Examples:

fabs( 2.4 ) returns 2.4

fabs( -3.8 ) returns 3.8

*******************************************

or subtract greater-smaller

[er_mohit]

try this way

  Interval(timestamp_to - timestamp_from, 'hh:mm') as rest_time

[#6]

Hi,

Please find the attached file. I hope it helps you

Thanks and Regards,

S. Amuthabharathi

[qw_johan]

Thanks 🙂 it helped