memotech
Forum Replies Created
-
Forum: Plugins
In reply to: [Calculated Fields Form] Calculate Difference Between Two times (HH:mm)Sorry, we misunderstood,
The function of calculating the difference between the 2 dates works very well.
Now I would like to sum two time differences. See photos and explanations above. I used :DATETIMESUM(fieldname1,'h:i',TIMETODECIMAL(fieldname13,'h:i','i'), 'i')But it does not work.
the fieldname1 and fieldname13 are the results of the formula you sent mefieldname1 :
(function(){var o = DATEDIFF( fieldname4, fieldname3, 'hh:ii', 'h'); return CONCATENATE(o['hours'], ':', o['minutes']); })()fieldname3 :
(function(){ var o = DATEDIFF( fieldname12, fieldname11, 'hh:ii', 'h'); return CONCATENATE(o['hours'], ':', o['minutes']); })()fieldname15 :
DATETIMESUM(fieldname1,'h:i',TIMETODECIMAL(fieldname13,'h:i','i'), 'i')is that more understandable?
thanks
Forum: Plugins
In reply to: [Calculated Fields Form] Calculate Difference Between Two times (HH:mm)Hello again,
To continue in the same project, I would like to sum 2 times differences
Exemple :
– Morning Start Time, Morning Finish Time, the difference
– Afternoon Start Time, Afternoon Finish Time, the difference
– and the Sum of the 2 differences (see the photo)
the difficulty is that I can’t do any operation with the results calculated previously, they are concatenated values
Thank you for your support.
Forum: Plugins
In reply to: [Calculated Fields Form] Calculate Difference Between Two times (HH:mm)ok thanks a lot
Forum: Plugins
In reply to: [Calculated Fields Form] Calculate Difference Between Two times (HH:mm)thank you very much,its working
Is it possible to format the result like 00:00 (with the zero and not 0:0)
exemple :
Start time 03:43
Finish time 05:49
Actual result 2:6
More nice like 02:06
thanks