LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Averaging times (similar to lap times) cqmman Excel Discussion (Misc queries) 1 June 22nd 07 11:15 PM
Still need help: filtering data bewteen worksheets dweezy Excel Worksheet Functions 2 October 5th 06 01:55 PM
Calculation of hourly rate times hours times 1.5 Newbusinessbod Excel Worksheet Functions 1 December 6th 05 04:44 PM
How are relay leg times or driving times entered and totaled? commissioner Excel Worksheet Functions 1 July 26th 05 09:27 PM
Charting and analyzing Times' times data for trends Johnny Excel Discussion (Misc queries) 1 May 5th 05 01:36 AM


All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"