LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default Calculating the number of entries between 2 times

I am working on a Dispatch records workbook. I am trying to get counts of
entries between 2 time frames. Example, How many entries between 8:00AM and
9:00AM, 9:00AM and 10:00 AM etc. I can get counts using less than, more than,
and equal, but not have had much luck with getting counts between 2 values. I
would like to also get response times(the time the call is received to when
it is dispatched) between 2 times. Any suggestions?

 
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
Calculating Times Chris waller Excel Discussion (Misc queries) 3 August 11th 09 08:31 PM
Allow times OR certain text entries Horatio J. Bilge, Jr. Excel Discussion (Misc queries) 3 October 4th 07 08:37 PM
re calculating numbers to times Hein Excel Discussion (Misc queries) 2 October 3rd 05 08:17 PM
calculating entries John Excel Worksheet Functions 1 September 28th 05 06:54 AM
Calculating times gibbylinks Excel Discussion (Misc queries) 4 August 23rd 05 01:27 PM


All times are GMT +1. The time now is 02:58 PM.

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"