Got it. One extra hour per day…the original post read like one extra hour the entire year…J Javier, Javier Valencia, PE 14315 S. Twilight Ln. Olathe, KS 66062 Home: 913-397-9605 Office: 913-829-0888 Cell: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Tom Hart Sent: Thursday, January 19, 2017 4:57 PM To: [email protected] Subject: Re: [RBASE-L] - Datetime question 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 <tel:(913)%20397-9605> Office: 913-829-0888 <tel:(913)%20829-0888> Cell: 913-915-3137 <tel:(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.
-- 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.
