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 biv343 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: *

  • Users: wrburch
  • Content: Threads
  • Order by date
  1. 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
  2. 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...
  3. 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.
  4. 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
  5. 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?
  6. 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