Combining numerous worksheets into one

[bethie4rmb]

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

 

[Andrew Poulsom]

For combining the data see:

http://www.rondebruin.nl/copy3.htm

To convert your times, try eg:

=HOUR(A1)+INT(MINUTE(A1)/60/0.25)*0.25

 

[bethie4rmb]

Thanks for the link. I will have to concentrate on learning how to do a macro later tonight. Hopefully, I will get it and make it work. They look long and scary!! :wink:

I did try the formula for my calculating problem and it returned 12 hours for 12hrs:28min. I need it to return 12.5. Thanks for your time and help!!!

 

[Andrew Poulsom]

For me returned 12.25 when formatted as general.

 

[bethie4rmb]

I don't know what I am doing differently but even so 12 hours and 28 minutes needs to come in as 12 and 1/2 hours. I didn't try it on any others. Maybe one of my problems is because I am trying to change a number that is a formula of time? I don't know!