View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Sapphyre Sapphyre is offline
external usenet poster
 
Posts: 20
Default How to make a Formula containing times.

How can I make a formula calculate how many occurances of a specific time
frame happened in Sheet 1, column A, and put it in Sheet 2, column A, B, C?

Example of the colums I'm speaking of:

Sheet 1: contains start time of projects during 3 different shifts
A
START TIME (Header)
07/01/07 03:00
07/01/07 05:50
07/01/07 07:00
07/01/07 11:00
07/01/07 15:10
07/01/07 18:37
07/01/07 23:01

Sheet 2:
A B
C
7a-3p Shift (Header) 3p-11p Shift (Header) 11p-7a Shift (Header)
2 2
3

7a-3p=07:00 a.m. - 14:59 p.m., 3p-11p=15:00 p.m. - 22:59 pm., and
11p-7a=23:00 - 6:59 a.m.,

Any help would be appreciated.
Thank you.