In Progress

Calculate Hours

Hello,

I need to have a macro/VBA that will do the following:

For each date (Column B), search for an individual tag (Column D) and subtract the latest time stamp from the earliest time stamp (Ignore all the other timestamps). The Macro should be able to go over ~15,000 rows. There is about 15 dates and 50 individuals tags.

For example: On the attached XLS, For 9/7/2012 and the tag number 22886 there are total of 5 timestamps.(Highlighted in Yellow)

.

The macro should take the latest time stamp for that date (18:27) and subtract the first time stamp of that date (10:01). Please note that the time stamps won’t be necessarily in ascending or descending order.

The result will be 18:27-10:01= 8:26

The results should be placed different tab summarized. See also the attached xls.

Thanks,

Cooper

Skills: Excel, Visual Basic

See more: cooper, calculate different, xls visual basic, hours dates, able calculate, xls tab, macro calculate, excel macro order, search macro, order xls, excel search macro, search macro excel, search ignore, vba hours, date vba excel, date vba, excel macro search, excel visual date, macro date excel, macro vba excel example, subtract excel, vba excel time, excel subtract, vba date excel, xls order

About the Employer:
( 6 reviews ) Brookline, United States

Project ID: #2538121

Awarded to:

mrbrave

Same thing I have done 2 days ago.....see my last review.....Can do this in 1 hour..Thanks

$35 USD in 1 day
(73 Reviews)
5.4

13 freelancers are bidding on average $71 for this job

nagybatonyi

Please, see a working sample in PMB! Regards

$45 USD in 1 day
(40 Reviews)
5.4
microk

Expert Here. Please check PM..

$33 USD in 2 days
(19 Reviews)
4.1
him76

hi, please check pm.

$35 USD in 1 day
(12 Reviews)
3.6
rohitpithisaria

Hi.. I would like to apply for the job.

$50 USD in 2 days
(4 Reviews)
3.0
mukapu

Hi, Understand the requirements to calculate the attendance hours from the access/swipe machine record. Please see PMB.

$50 USD in 1 day
(2 Reviews)
2.0
andrea0286

I can do the job. I have a long Excel and VB job experience.

$90 USD in 2 days
(1 Review)
1.0
richierich01

I am hard worker,with positive attitude towards work.

$100 USD in 2 days
(0 Reviews)
0.0
sgadi

I understood the problem. I can solve it.

$250 USD in 10 days
(0 Reviews)
0.0
patelravi1

Hi I can do this in 2 hours. Please check my PMB

$30 USD in 1 day
(0 Reviews)
0.0
sameeragayashan

I can do this project for you.

$30 USD in 1 day
(0 Reviews)
0.0
guptajoydeep

Dear Project Owner, I am an expert in VBA and I can assure you 100% completed work exceeding your expectation. Automation and coding is my area of passion. You can visit my portfolio to review the tools that I h More

$140 USD in 2 days
(0 Reviews)
0.0
lsdidkdkdkdk

Please check the PMB

$30 USD in 1 day
(0 Reviews)
0.0