Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access Time Calculation
This group is great - I've already saved hours of searching!
I am trying to do an Access report measuring elapsed times in warehouse product picking. I want to find the minimum time a person spends on a pick. I tried the min function on the elapsed time in a section footer on the report, but occasionally my elapsed times are zero (warehouse system glitch) and this is what I get back.. If my report has a zero, I want to ignore it and report the next higher minimum time. How do I get the minimum time greater than zero? Thanks, Melric |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access Time Calculation - Wrong Group
Sorry - I posted into the wrong group. I re-posted in the access folder
"melric" wrote: This group is great - I've already saved hours of searching! I am trying to do an Access report measuring elapsed times in warehouse product picking. I want to find the minimum time a person spends on a pick. I tried the min function on the elapsed time in a section footer on the report, but occasionally my elapsed times are zero (warehouse system glitch) and this is what I get back.. If my report has a zero, I want to ignore it and report the next higher minimum time. How do I get the minimum time greater than zero? Thanks, Melric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop time - start time calculation | Excel Worksheet Functions | |||
Time calculation (Subraction of Idle Time) | Excel Discussion (Misc queries) | |||
Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
access my data from my master worksheet while calculation is don. | Excel Worksheet Functions |