Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
So I'm trying to write a macro to count a number of records built on a shift
and output the data in a form similar to the one below. Date Count 6/20/08 5 6/21/08 6 The problem i'm having is that our 2nd shift runs from 6:00 pm - 4:00 am and I would like all of the data from that shift to be counted on the shift start date. Ie, if i have a record on 6/21/08 2:15 AM that should be counted as 6/20/08. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Issue | Excel Discussion (Misc queries) | |||
Date Issue | Excel Programming | |||
Date issue | Excel Discussion (Misc queries) | |||
DATE ISSUE! | Excel Worksheet Functions | |||
date issue | Excel Programming |