bethie4rmb
New Member
- Joined
- Jun 5, 2006
- Messages
- 28
Hello all,
I come here and search the message boards in order to save my sanity when I have Excel issues. Thank you for posting answers to anything and everything. I am relatively good at using excel but have no background in Macros and have only used the functions that are in formulas I have used from here. So here is my new problem and if it could be the most idiot proof answer, that would work for me!!
I have an employee swipe report that comes in daily from an outside source. Once I have all days, I need to combine them all into one sheet. I have been manually moving them to the same workbook and copying and pasting from there, then using sort. The reports come in like this.....
BADGE PUNCH TIME READER
NUMBER DATE NUMBER
70603 9/5/2006 4:59 4
70603 9/5/2006 17:07 3
70609 9/5/2006 6:06 4
70609 9/5/2006 21:28 3
70612 9/5/2006 7:18 2
70612 9/5/2006 14:23 1
70612 9/5/2006 14:23 1
70613 9/5/2006 10:22 3
I use a formula to figure time and manually add in their names and shift worked. So it is a lot of work.
I have two questions is it possible to move all the info and have it sorted so I will only have to add in name, shift and formula for calculating time?
Also, I need to know if there is a way to make my time worked turn into quarters of an hour. Example: 1:36 = 1.5, 1:45 = 1.75 and so on.
I am sorry if this is poorly explained. I will try to explain better if you have specific questions.
Beth
I come here and search the message boards in order to save my sanity when I have Excel issues. Thank you for posting answers to anything and everything. I am relatively good at using excel but have no background in Macros and have only used the functions that are in formulas I have used from here. So here is my new problem and if it could be the most idiot proof answer, that would work for me!!
I have an employee swipe report that comes in daily from an outside source. Once I have all days, I need to combine them all into one sheet. I have been manually moving them to the same workbook and copying and pasting from there, then using sort. The reports come in like this.....
BADGE PUNCH TIME READER
NUMBER DATE NUMBER
70603 9/5/2006 4:59 4
70603 9/5/2006 17:07 3
70609 9/5/2006 6:06 4
70609 9/5/2006 21:28 3
70612 9/5/2006 7:18 2
70612 9/5/2006 14:23 1
70612 9/5/2006 14:23 1
70613 9/5/2006 10:22 3
I use a formula to figure time and manually add in their names and shift worked. So it is a lot of work.
I have two questions is it possible to move all the info and have it sorted so I will only have to add in name, shift and formula for calculating time?
Also, I need to know if there is a way to make my time worked turn into quarters of an hour. Example: 1:36 = 1.5, 1:45 = 1.75 and so on.
I am sorry if this is poorly explained. I will try to explain better if you have specific questions.
Beth