Search results for query: *

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...

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...

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...

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

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?

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...