re : How to delete a time range in the raw datas.

D

ddiicc

Hi there,
I hope someone could help me out on this.

Senario :
Column A = Date (eg. 3/26/2007)
Column B = Time (eg. 7:00:19 AM)

I have datas daily.. always starting on at 7am to the next day 7am.
Therefore in this data, the data is produced in 3 Shift work.

A shift = 7am to 3pm
B shift = 3pm to 11pm
C shift = 11pm to 7am.

I would to have a macro to do the following :-
When I want A shift datas, it will delete the B & C shift datas.
When I want B shift datas, it will delete the A & C shift datas.
When I want C shift datas, it will delete the A & B shift datas.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

re : How to delete rows. 0
Splitting a number in one cell into other cells 0
To enter data in columns in required order in some special way and toensure this 2
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Select value on a cell by matching value of two cells 1
How can I make Excel recognize a time period 3
Selec the column to add in a listbox 1
Pivot table 3

Top