Invoice Action Hours Quantity Miscalculation

David Carlson david.carlson.417 at gmail.com
Fri Dec 30 17:48:25 EST 2016


Does the leap second happen for everyone at 12:59:59 UT or does it happen
at local time?

David C

On Thu, Dec 29, 2016 at 7:23 PM, Gurdeep Singh (Guru) <oyeaussie at gmail.com>
wrote:

> 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
> >
> >
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


More information about the gnucash-user mailing list