Find Jobs
Hire Freelancers

Calculate Hours

$30-250 USD

In Progress
Posted over 11 years ago

$30-250 USD

Paid on delivery
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
Project ID: 2538121

About the project

13 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Same thing I have done 2 days ago.....see my last review.....Can do this in 1 hour..Thanks
$35 USD in 1 day
5.0 (73 reviews)
5.4
5.4
13 freelancers are bidding on average $71 USD for this job
User Avatar
Please, see a working sample in PMB! Regards
$45 USD in 1 day
4.9 (40 reviews)
5.4
5.4
User Avatar
Expert Here. Please check PM..
$33 USD in 2 days
4.8 (19 reviews)
4.1
4.1
User Avatar
hi, please check pm.
$35 USD in 1 day
4.7 (12 reviews)
3.6
3.6
User Avatar
Hi.. I would like to apply for the job.
$50 USD in 2 days
5.0 (4 reviews)
3.0
3.0
User Avatar
Hi, Understand the requirements to calculate the attendance hours from the access/swipe machine record. Please see PMB.
$50 USD in 1 day
5.0 (2 reviews)
2.0
2.0
User Avatar
I can do the job. I have a long Excel and VB job experience.
$90 USD in 2 days
5.0 (1 review)
1.0
1.0
User Avatar
I am hard worker,with positive attitude towards work.
$100 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I understood the problem. I can solve it.
$250 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I can do this in 2 hours. Please check my PMB
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do this project for you.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 have created on Excel VBA
$140 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please check the PMB
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Brookline, United States
5.0
6
Payment method verified
Member since Mar 26, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.