Combining numerous worksheets into one

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!! :biggrin:
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
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

bethie4rmb

New Member
Joined
Jun 5, 2006
Messages
28
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!!!
 

bethie4rmb

New Member
Joined
Jun 5, 2006
Messages
28
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!
 

Forum statistics

Threads
1,141,629
Messages
5,707,506
Members
421,511
Latest member
mgroah1

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top