Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet that lists a number of cases that are picked by a
colleague and a time they start and a time they finish. I'm trying to work out how many cases are picked between each hour. Column F15:F1014 has the has the list of Cases Column J15:J1014 Start Time Column K15:K1014 Finish time I am trying to work out what has been completed between each hour starting at 06:00am through to 05:59am the next day using the finish time. ie 06:00-07:00 and so on. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Averaging times (similar to lap times) | Excel Discussion (Misc queries) | |||
Still need help: filtering data bewteen worksheets | Excel Worksheet Functions | |||
Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) |