LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anthony
 
Posts: n/a
Default Formula help - please !

Hi and Happy New Year to all

I need a formula (and don't know where to start) for the following

In a worksheet I have a list of dates in column A and times in column B, I
want a formula to count each time a certain date and time before 12noon
appear in columns A and B, and likewise the amount of times a certain date
and time appear after 12noon.

eg, basic worksheet

A B
1Jan 11:23
1Jan 13:34
2Jan 09:10
2Jan 11:34
2Jan 15:43

so the result for 01Jan before 1200 would be 1, the result for 01Jan after
1200 would also be 1, the result for 02Jan before 1200 would be 2, and so on.

I think think this could be solved using 'arrays' in the =SUMPRODUCT formula
but I don't know how to write the formula

Appreciate any help

Kind regards
Anthony

 
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
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
Hide formula skateblade Excel Worksheet Functions 10 October 15th 05 08:36 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 01:27 AM


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