I found what I needed, my client started staying open 1 extra hour from 7 to 8 pm so I created a new column for Ihr and calculated anything gt 19. This seemed to solve my problem
Tom Hart On Thu, Jan 19, 2017 at 4:32 PM, Javier Valencia < [email protected]> wrote: > I am not sure I understand what is it that you need. When is the extra > hour in question? At the end of the year or somewhere in between? I think > the easiest way would be to run a total for the year with the DateTime > field between two date-times that do not include the hour in question and > another total for with the DateTime field between two date-times that do > include the hour. > > > > Javier, > > > > Javier Valencia, PE > > 14315 S. Twilight Ln. > > Olathe, KS 66062 > > Home: 913-397-9605 <(913)%20397-9605> > > Office: 913-829-0888 <(913)%20829-0888> > > Cell: 913-915-3137 <(913)%20915-3137> > > > > *From:* [email protected] [mailto:[email protected]] *On > Behalf Of *Tom Hart > *Sent:* Thursday, January 19, 2017 3:58 PM > *To:* [email protected] > *Subject:* [RBASE-L] - Datetime question > > > > I have a user that has opened her business for 1 hour more for 2015 and > wants to know if it was worth it. My sales table has a datetime stamp for > every transaction. Is there a way to show a total for the year by breaking > out that extra hour. > > > > Tom Hart > > -- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
