| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum if value is bewteen 2 times
Clarification:
If J in 6:05 AM and K is 7:15 AM, do the cases go to the 6 AM or the 7 AM bin? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Charno" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum if value is bewteen 2 times
....and will the overnight ones juts be identified by the end time being
earlier than the start time? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bernard Liengme" wrote in message ... Clarification: If J in 6:05 AM and K is 7:15 AM, do the cases go to the 6 AM or the 7 AM bin? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Charno" wrote in message ... 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. |
| Reply |
| 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) | |||
Hybrid Mode
