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 Chriss Miller 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. JohnnyD

    averaging time

    Jeff, JV's suggestion does work, but I have about 350 entries a day to key, so it is very time consuming. I took a page out of your last suggestion and developed a resolve that is less time consuming. in row W3, I entered 24:00, which pushes the date out 1 day. I then changed the IF statement...
  2. JohnnyD

    averaging time

    I think I figured out what is causing the problem: It is being skewed by times that cross midnight. For example: load arrives 23:30 and is unloaded at 00:10. The formula to calculate the time is calculating correctly (showing 0:40), but is making the average jump because the system thinks...
  3. JohnnyD

    averaging time

    I am creating a spreadsheet that has times for unloading freight. I have formatted the columns to be military time. I have a function that subtracts the two times entered (start & finish) to give me total unload time. I am having an issue with the formula to average the unload time and get it...
  4. JohnnyD

    Form Question - Number of characters

    Thanks a lot. That worked with ease. Thanks for helping us "beginners" out.
  5. JohnnyD

    Form Question - Number of characters

    I have built a form in which our personnel will enter various issues. I inserted a text box for them to type the issue but the issue can only be 255 characters long. Can I lengthen this? How?
  6. JohnnyD

    Sorting times starting at 6 a.m. instead of midnight

    I have created a table of deliveries to an assembly plant. The plant runs from 06:00 to 04:30 (a.m. to a.m.) each day. When I run the queries from the table or try to creat a report from the query the times always sort from 00:30 on through the day. I want to start the sort at 06:00 instead...

Part and Inventory Search

Back
Top