Invoice Action Hours Quantity Miscalculation

[Gurdeep Singh (Guru)]

Hello Derek,

Thanks for the response.

I think it should be a feature to do automated calculations. Example: If
the action selected is Hours, the qty should take hh:mm as input.

Regards.



On Fri, Dec 30, 2016 at 7:10 AM, Derek Atkins <derek at ihtfp.com> wrote:

> 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
>
>