Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I make calcutaions with clock times? | Setting up and Configuration of Excel | |||
Comparing Times To Make Sure No Overlap | Excel Worksheet Functions | |||
IS THERE A FORMULA TO MAKE E=6:00PM ETC SHIFT TIMES AND HOURS | Excel Worksheet Functions | |||
How do I make a chart with several times during a day | Excel Discussion (Misc queries) | |||
Do I have to make my times be numbers to get a true average? | Excel Discussion (Misc queries) |