# Combining numerous worksheets into one

#### bethie4rmb

##### New Member
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.....

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

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
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!!!

For me returned 12.25 when formatted as general.

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!

Replies
2
Views
336
Replies
10
Views
271
Replies
2
Views
105
Replies
12
Views
440
Replies
6
Views
446

1,219,574
Messages
6,149,087
Members
450,857
Latest member
Karomi

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back