totalling the hours

[mtagliaferri]

Hi, I have been looking for some answear, but haven't find the proper one!!
I have a form containing a number of records showing the hours worked in format HH.MM at the end of the form I have the sum of the hours, but the result is not correct.
To make it simple to understand, actualy the total of hous for 11.55 and 11.14 gives me the result of 22.69 but the correct result should be 23.09 (23h and 09m and not 22h and 59m)
How can I get the right total???
Marco

 

[elbweb]

change the format of the field to a date time, with the specified time format you want, it should then give you the right answer, if not youll have to do code to run through it.

 

[RV]

Search the forum, questions on time and date calculations have been asked before 'bout a zillion times

RV