Find Jobs
Hire Freelancers

excel formula employee timesheet

$10-30 USD

Closed
Posted about 6 years ago

$10-30 USD

Paid on delivery
I have a raw excel date from a time stamp log that indicates when employees log in and log out during a shift - I need to calculate the total hours worked each day based on the timestamps logged in/out - not simply start of shift - end of shift. Raw data is sorted into three columns - 1) unique employee ID, 2) timestamp and 3) direction status either IN or OUT. Again, I need to calculate total hours worked per calendar day. Most work day shift (7am - 4pm weekdays; a few work night shits 6pm-6am).
Project ID: 16595811

About the project

55 proposals
Remote project
Active 6 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
55 freelancers are bidding on average $26 USD for this job
User Avatar
Hi there..... Warm Greetings We came along with your request for excel formula employee timesheet and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Data Processing, Excel, Visual Basic We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$50 USD in 1 day
4.9 (400 reviews)
8.1
8.1
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$30 USD in 1 day
4.9 (431 reviews)
7.7
7.7
User Avatar
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$40 USD in 1 day
4.9 (131 reviews)
7.1
7.1
User Avatar
Hello there, I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss timeline and budget. Thanks A
$35 USD in 1 day
4.9 (178 reviews)
6.6
6.6
User Avatar
Hi, After reading your project description about creating an Excel file that will calculate the employees' total hour of duty per day based on the time logged in and out, I feel like you have me in mind when creating the project. I have all it takes to deliver. I am confident I can exceed your expectations since I am accustomed to doing this sort of job on a regular basis. I am highly skilled in the following areas: 1. Daataa Entry 2. Excel I am passionate about flawless results and I can assure you of a job well done. Please refer to my reviews for more details. Looking forward to discussing the project details with you.
$30 USD in 1 day
4.9 (60 reviews)
6.6
6.6
User Avatar
Hi, I am interested in working on this task. I went through the sample file attached. I can write a Macro to capture the number of hours worked based on In and Out time and effective Day hours and Night Shift Hours. Looking forward to hear from you. Best Regards, Akila.K
$25 USD in 1 day
5.0 (50 reviews)
5.7
5.7
User Avatar
- Worked close to 3-4 projects via Freelancer on Check-in Checkout timings. - For the employee list... as in Attehndance v2, can get for all employees across dates, on the total hours worked. - Using a button click. - Have expertise in Excel macros and solutioning. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on recent projects.
$60 USD in 2 days
4.6 (53 reviews)
6.1
6.1
User Avatar
I have more than 10 years of experience in Excel and VBA with 100% client satisfaction history. See my profile for client review.
$30 USD in 1 day
4.8 (35 reviews)
5.6
5.6
User Avatar
Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application -- Expert in ASP.NET,MVC -- JS,Google extensions and google scripts I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$35 USD in 1 day
4.9 (61 reviews)
5.5
5.5
User Avatar
Hello, I can write a VBA macro to process such file, data would be in one sheet and results in another. I had a an offer to write a macro for similar project earlier, but I refused as data had no "in" and "out" markers and I expected a lot of problems with it. This data set has the markers, but also many bad entries. I would need an instruction how to handle them. Example ID 252, 2018-01-02 09:20:54 IN, 2018-01-02 09:52:42 IN. Sometimes there are 2 outs in the row. Clearly visible when sorted by ID. Best Regards
$30 USD in 1 day
5.0 (64 reviews)
5.3
5.3
User Avatar
Hi - I am an IT professional with 2 decades of experience. I have 2 patents in US. As far as excel is concerned i am quite well versed with the technology which i have mastered over 2 decades. I can handle simple excel with formulas to complex power pivots with macros with ease. Having worked for customers like Apple, Microsoft, Boeing, TI for most part of my career I am quite seasoned with professionalism and specificity in term of solutions. Give the task to me and rest assured that you are in safe hands. Looking forward for an opportunity to add value and feel proud about it.
$21 USD in 1 day
4.9 (26 reviews)
4.9
4.9
User Avatar
Hi I am an excel VBA expert. I have done a similar job for my company. Please go through my profile and my reviews so that you can be confident about me. Hope to chat with you soon :) Thanks Sajid Khan
$25 USD in 1 day
4.2 (67 reviews)
5.8
5.8
User Avatar
Hi there! Try me for 100% satisfaction and on-time work. Can do all stuffs related to excel. Let's chat to discuss details. Awaiting your response, thanks!
$25 USD in 1 day
4.9 (30 reviews)
4.0
4.0
User Avatar
Hello Dear, I would like to help you. I read your project details and able to start right now. so you can hire me to get a Quality Service. Thanks Tanaya
$24 USD in 0 day
4.9 (26 reviews)
4.1
4.1
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
5.0 (7 reviews)
3.8
3.8
User Avatar
A proposal has not yet been provided
$30 USD in 3 days
5.0 (8 reviews)
3.4
3.4
User Avatar
Hi, I have experience in working excel for 9 years. I can do this job easily. First draft will be in 5 hours. thanks
$25 USD in 0 day
5.0 (3 reviews)
3.1
3.1
User Avatar
Experienced Excel/Word user based in Brisbane, Australia, with office and technical background. Good with maths, spreadsheet functions, and macros. Native English speaker. Will it always be 1 calendar month?
$11 USD in 2 days
4.6 (5 reviews)
2.7
2.7
User Avatar
A proposal has not yet been provided
$55 USD in 1 day
5.0 (4 reviews)
2.2
2.2
User Avatar
I am very profesional on Excell. I have done many data processing project by using VBA code that I can show you. This solution will reduce mistake and faster than human doing. I also can create very cute template dashboard using Advanced Excell technique to visualise your data. Please discuss more detail over chat. So I will solve your problem by using Advanced Excell technique such as Advanced formula or event VBA code. Contact me. Thank Nguyen Tuan Anh
$15 USD in 1 day
3.5 (4 reviews)
2.1
2.1

About the client

Flag of BRUNEI DARUSSALAM
Brunei Darussalam
0.0
0
Member since Mar 30, 2018

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.