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
OUTPUT
2 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.