| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum if value is bewteen 2 times
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 | |
|
|
Similar Threads
|
||||
| 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) | |||
Threaded Mode
