Hello to everyone,
i'm trying to get a time calculation using no code with 3 (text-)fields.
The first is starttime using the conditions: itself not empty, endtime not empty, starttime is like 00:00:00
The following rule is implemented:
(((number(substring(../my:endtime, 1, 2)) * 3600) + (number(substring(../my:endtime, 4, 2)) * 60)) - ((number(substring(., 1, 2)) * 3600) + (number(substring(., 4, 2)) * 60))) div 60
The second is endtime, containing the similar conditions as starttime and has this rule:
(((number(substring(., 1, 2)) * 3600) + (number(substring(., 4, 2)) * 60)) - ((number(substring(../my:starttime, 1, 2)) * 3600) + (number(substring(../my:starttime, 4, 2)) * 60))) div 60
The thrid field (result) is the target for the rules settings.
The first test was fine, it worked properly. But it only worked for one time! Everytime i enter values in starttime or endtime the result field stays empty - it drives me mad!
So if anyone as any idea - please do not let my die stupid!
Best regards
Emilio111