LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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.

 
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 make calcutaions with clock times? Clarence Setting up and Configuration of Excel 1 January 14th 07 06:13 PM
Comparing Times To Make Sure No Overlap Matt Excel Worksheet Functions 0 June 29th 06 04:37 PM
IS THERE A FORMULA TO MAKE E=6:00PM ETC SHIFT TIMES AND HOURS Angel Devoid Excel Worksheet Functions 2 December 28th 05 06:25 PM
How do I make a chart with several times during a day [email protected] Excel Discussion (Misc queries) 6 December 23rd 05 02:13 PM
Do I have to make my times be numbers to get a true average? Leslie Excel Discussion (Misc queries) 1 December 9th 05 02:48 PM


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