Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. wrburch

    Converting seconds to Hours, minuters,seconds

    Thanks, the synapsevampire formula works
  2. wrburch

    Converting seconds to Hours, minuters,seconds

    I have a formula to calculate the difference in time by seconds, i.e 108,000. When I try to convert to time using crtimefromsecssincemidnight(@total time), I get the error "out-of-range(0-86400). Is the a way to give me the total time 30:00:00 hours? Thanks, Bill B
  3. wrburch

    Pulling data for every 3rd day

    Thanks for the help. Had to do some minor modification to the formula but works great.
  4. wrburch

    Pulling data for every 3rd day

    Is there a formula that will allow me to pull data just for every third day in a date range? For example, my end date is today and I want to go backwards to Jan 1st for every 3rd day. This will be a daily report that would give each shift (A,B,C) their cumulative report for data. Thanks for...
  5. wrburch

    How can I pull data for a week using start time of 7:00AM Sunday

    Thanks Brian, this worked great with 1 change. In the third line I had to use Currentdate-2 instead of maximum(lastfullweek) to capture the early morning Sunday times. Thanks for the help!! Bill B
  6. wrburch

    How can I pull data for a week using start time of 7:00AM Sunday

    Instead of using the filter LastFullWeek, I need a formula that runs Sunday 7:00AM thru next Sunday 6:59AM. I have separate Date and Time fields with time as a string. (Created Date) is a DateTime field but only has 12:00AM as the time. (Created Time) shows as 070000. Any help is appreciated.
  7. wrburch

    Fiscal Year

    I need to group 10 years of data by fiscal year using just a date field (CreatedDate). FY is 10-1 thru 9-30 for years 2005-2014. Is there an easy formula out there? WRB
  8. wrburch

    running 90-day intervals each month

    I am in need of a date formula that runs a 90-day interval for the previous 4 to 2 months prior to current month, i.e it's Nov but I need July1 thru Sept30. Can you help?
  9. wrburch

    How do I create a 24-hour workshift that starts at 7:30AM each day?

    How do I create a 24-hour workshift that starts at 7:30AM each day? There are 3 shifts A,B,C that rotate thru the year. I have a date and time field to use in my table. Help?

Part and Inventory Search

Back
Top