adnanesa3d

Hello
first of all I want to thank you for your enormous support, I really appreciate, you are right I did not specify my data structure, I explain my data structure and the display problem that I have:
-I have 2 fieldname (Fieldname1 and Fieldname2) each fildname indicates an hour with the minutes example: fildename1 XXHYY and fildename2 AAHBB
I try to do subtraction hours (faildname 2 – fildename 1) I used the following program that you wrote:
(function () {
    var A = CDATE (fieldname1, ‘hh’) * 1,
        B = CDATE (fieldname1, ‘ii’) * 1,
        X = CDATE (fieldname2, ‘hh’) * 1,
        Y = CDATE (fieldname2, ‘ii’) * 1,
        C = A * 60 + B,
        Z = X * 60 + Y,
        M = C-Z;

    return FLOOR (M / 60) + ‘:’ + (M% 60);
}) ()
 the code at the top works very well, but there is a small problem is that the result between 0-9 for minutes, it is displayed like this 9 instead of 09 Mintues
I give you an example if I try to do this calucl with the code above: 12h23-10h20 = 2h3 instead of displaying 02h03, on the other hand for this kind of calculation the code works very well: 23h44-15h23 = 8h21 there is no problem.
I’m not trying to modify or customize the calculator I’m just trying to solve the display problem that I explained above
Thank you for your understanding

Hello
I really appreciate your help, the solution that you have indicated works very well, thank you very much but I have a little problem whenI try to do subtraction of hours the displayed result is not always correct :
For example if I try to make this calculation 22h23 – 20h20 the displayed result is 2h3 min and is not 2h03 min otherwise for the other calculations there is no problem

Thanks =)

Hello
I had the same problem, I try to add hours and minutes, I succeeded is in the base 100,, I wrote the code that you put in the comment above in the box of equation in Advanced equation’s editor but it doesn’t work unfortunately
Could you help me solve the problem? to display and add the results in Hours and minutes?