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: 37
Default Counting time-frames

Not sure about the subject - best description I could come up with.
I have a column which shows elapsed times in hours and minutes for various
jobs. What I want to do is count how many of these fall into various time
frames e.g 1 hour to 1 hour and 30 minutes, 1hour and 31 minutes to 2 hours
etc. All I need is a count. I don't want to have to the sort the sheet to do
this as it needs to be part of the overall sheet, and if possible I'd like to
avoid vba although if that is the only way around it - so be it.
 
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
How do I subtract time where hh:mm:ss:ff (frames = 30 frames/sec) KJ7 Excel Discussion (Misc queries) 14 December 3rd 16 10:03 AM
Freeze /Split frames Thor Excel Worksheet Functions 4 June 10th 08 12:29 AM
Can Excel Calculate time down to Frames i.e. Television or Film Bill D. Toronto[_2_] Setting up and Configuration of Excel 1 March 29th 08 09:14 AM
freezing frames Bob Griendling Excel Worksheet Functions 4 July 1st 06 10:58 PM
Calculation of Hrs and Mins from 2 Time Frames Corey Excel Worksheet Functions 6 May 31st 06 05:12 PM


All times are GMT +1. The time now is 01:29 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"