Invoice Action Hours Quantity Miscalculation

Derek Atkins derek at ihtfp.com
Thu Dec 29 15:10:41 EST 2016


Hi,

On Thu, December 29, 2016 7:37 am, Gurdeep Singh (Guru) wrote:
> Hello All,
>
>
> I am using the Hours action in the invoice to bill my customer as per the
> number of hours. Please see attached screenshot.

The "Action" is just a string to supply to the invoice recipient.  It has
no meaning to GnuCash.

> Taking these hours into consideration:
>
> 22.59, 9.46, 1.14, 4.04
>
>
> The calculation of these hours should be 38 Hrs and 03 Mins. But the
> invoice calculates it as 37 Hrs and 23 Mins.

Correct, because you're entering in 22 59/100 hours, 9 46/100 hours, 1
14/100 hours, and 4 4/100 hours.

> It seems that the calculation is not done properly as time is calculated 1
> qty = 60 mins, but it seems like its calculating 1 qty = 100 mins.

You're assuming that you're entering h.m.  You are not.  You are entering
hours and fractions of an hour.  So 1h30m is 1.5, not 1.3.  That also
means that 22h59m should be entered as 22 + 59/60 == 22.983.

> Can this be fixed? Is there a setting for this as I did not see anything
> in
> the preferences or properties.

Yes, it can.  Fix your entries to be fractions of an hour :)

Hope this helps!

>
>
> Thanks.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant



More information about the gnucash-user mailing list