Calculation of hours

Good evening guys, how are you ?

I would like to calculate hours in 24h format.

Example 01:00 - 03:00 = 22:00.

Can you help me?? I am using Node Date & time difference but it is not bringing the correct result.


@armingrudd I noticed that you made a comment on other similar posts, can you help me?

Hello @Gabriel2020 ,

Can You explain your example :
01:00 - 03:00 = 22:00.
how it 22:00 ?

Of course, sorry for not making it clear.

I am carrying out a calculation to define the loading times for the operations for which I am responsible.

This way I have the CPT time (time when the truck should leave) and the loading time.

CPT - column last cpt

Charging time - ANTEC

Therefore, thinking about a 24-hour period, it would work as follows:

01:00 - 03:00 = 22:00

Another example that might be clearer.

00:00 AM - 02:00 = 22:00

02:00AM - 02:00 = 00h

@Gabriel2020 maybe insert a rule. If it is negative add 24h. If the times are identical it is 24h.

Hello @Gabriel2020 ,
You can use math formula node with expression like
“if( $Hours$ ==0,0,24-$Hours$)”
also give reference from attached image

Q13

OUTPUT

A13-PART 2

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.