Find Jobs
Hire Freelancers

Calculate and track time worked based on timestamp from first and last emails of the day

$30-250 USD

Imekamilika
Imechapishwa about 5 years ago

$30-250 USD

Kulipwa wakati wa kufikishwa
I need to log how many hours I worked in the last 12 months, based on the first and last email that I sent each day of the last year. I have two spreadsheets: - One with the time of all the emails I sent in the last 12 months - One where we need to log the time that I worked (and the way to log time is different depending if it is a week day or a weekend). Weekdays (Monday – Friday) The first email of the day should me marked as the first hour working, if it’s before 9am. If it’s after 9am, the day should start counting at 9am. The day ends with the last email of the day, or at 6pm, if there are no emails after 4pm. For example: • On March 5th 2018 o The first email is at 7h13. So the day starts at 7am. o The last email of the is at 9h32pm. So the day ends at 10pm. o Total hours worked: 7am – 10pm = 15 hours • ACTION – Log 15 hours on March 5th 2018 Weekends (Saturday and Sunday) One hour for each email sent on that hour. So, for example: • On March 4th 2018 • 3 emails sent between 8-9am = 1 hour • 2 emails sent between 7-8pm = 1 hour • 16 emails at 10h23pm = 1 hour • TOTAL: 3 hours
Kitambulisho cha mradi: 18868762

Kuhusu mradi

19 mapendekezo
Mradi wa mbali
Inatumika 5 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
Hi! I read the description and understand the project and mark the emails so that starting and ending time of the day can be known, I am very much sure to do this job with accuracy. Looking forward to your positive response. Thanks.
$100 USD ndani ya siku 3
4.9 (195 hakiki)
6.8
6.8
19 wafanyakazi huru wana zabuni kwa wastani $83 USD kwa kazi hii
Picha ya Mtumiaji
Dear sir, Thank you for giving the job opportunity that you have published here. As per your requirement, I would like to tell you that I have a strong command over Excel, Data entry, Data Processing, Data mining, Web scraping, Web searching etc. I have understood and agreed upon your given Job description and hence decided to work on this project with the following consideration, Payment: $80 Project Timeline: 3 days Further Discussion: Needed I welcome you to visit my portfolio at freelancer.com. My Profile- https://www.freelancer.com/u/imtiaznafis1#/reviews I am looking forward to giving my client quality output rather than just receiving remuneration. Therefore, I have a firm grasp of accomplishment of your assigned task accurately on due time without any disappointment. Thank You
$80 USD ndani ya siku 3
5.0 (17 hakiki)
7.0
7.0
Picha ya Mtumiaji
Hi There, I just went through your project description and happy to say that I can do this task PERFECTLY for you. I am an expert in advanced excel features and have already done a lot of similar kind of custom excel sheets for clients/business across the world. You can refer my profile to see my reliability, and if you are happy with those, lets start the task. I look forward to hearing from you soon. Thanks Priyal
$50 USD ndani ya siku 0
5.0 (197 hakiki)
6.8
6.8
Picha ya Mtumiaji
Hi there, I am a professional freelancer. I have good experience in web search, lead generation , data entry into excel spreadsheet job. I will calculate total time frame of the last year working days. I see it is easy to calculate. Let's calculate last 12 months total working hours. Cheers
$50 USD ndani ya siku 1
4.9 (89 hakiki)
6.3
6.3
Picha ya Mtumiaji
Hey there ! This his looks like an easy project for me. Just got to make the Excel Formula and get the Values you require. Can start work immediately and finish it off quickly with 100% accuracy. Check my reviews to get an idea about me work quality. Hope to hear from you. Thanks :)
$150 USD ndani ya siku 2
5.0 (67 hakiki)
6.4
6.4
Picha ya Mtumiaji
Hi, as you described in your project description that you need an excel expert. Microsoft excel is my top skill. I am software engineer basically. I know how to use tools. I can build Logic expertly. I can complete this task within given time span. Hope to hear from you. Consider me once.
$111 USD ndani ya siku 3
4.9 (45 hakiki)
4.8
4.8
Picha ya Mtumiaji
Greetings! I will surely get your project executed as required and you will get a superb result.I believe my dedication, experience, and advanced skills would be an ideal match for this position. I am one who embraces creativity, new ideas and able to work in fast-paced environments. I am very skilled in data entry, data mining, data scrapping, virtual assistance, web research, SEO, SMM, lead generation, Directory and other related programs submission. I’ve sound knowledge in Email merge, Linked In, Bulk Email, MS Excel (2003, 2007 &2010), MS Word (2003, 2007 &2010), Google Docs, Google Spreadsheet, HTML, Google Document, Google Ad wards, Drop box, Cloud storage, Trello and other required applications. Thank you and I look forward to the opportunity to work with you. Have a good day :) Md. Aftab Ahmed
$100 USD ndani ya siku 3
4.9 (16 hakiki)
3.6
3.6
Picha ya Mtumiaji
Hello! My name is Florian, and after seeing your listing I feel like we could collaborate well with each other on this project. I’m an Accountant based in Berlin, Germany. My specialties are Data Entry and Financial Analysis. My desired rate to complete the project is 170 USD according to the outlines milestones. I look forward to hearing from you later on in the week to learn more about this project. Cheers, Florian
$170 USD ndani ya siku 5
5.0 (2 hakiki)
3.5
3.5
Picha ya Mtumiaji
I am accurate, quick, and trustworthy in data entry. Please contact me if you are interested. Thank you!
$55 USD ndani ya siku 3
5.0 (5 hakiki)
2.9
2.9
Picha ya Mtumiaji
Sir/Mam I have gone through your description thoroughly. I can assure that I will calculate your working time accurately. As I am new to this website I don't have many Ratings. Just work with me once and I know you will want to work with me again as complete client satisfaction is my main motive. Expecting to discuss further details over chat. Thank You.
$30 USD ndani ya siku 1
5.0 (4 hakiki)
1.7
1.7
Picha ya Mtumiaji
I've done like these projects many locally. Therefore, I can very quickly finish this. Relevant Skills and Experience Data processing, data entry
$35 USD ndani ya siku 2
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I have excellent data entry and processing skills due to my strong attention to detail. I will double and triple check the entry in the log for the time worked each day. I fully understand the difference in working out the hours for weekdays and weekends, as you have described. I can have this project done in 3 days for you; if it is required on a tighter deadline please just let me know and I am sure I will be able to help.
$133 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Driven, analytical leader with strong work ethics and high personal values; a collaborator and influencer with a holistic/cross-departmental focus, resulting in an outstanding performance in day-to-day tasks and responsibilities.
$55 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hi there ! I believe I will be a great candidate for your job! I love to creat excel sheets and track dates, times and data. Your jobs looks like I can do it quickly and efficiently. I’ve worked as an Administrative Assistant most of my job career and many times my bosses asked me to do this sort of stuff for them. Among being a tracking freak, I know Microsoft Office, I’m tech savvy, time saver and earn my pay. My rate for my proposal is 20$/hour, 8ht day. Finishing early will obviously be less. Thank you for considering. Anayeli PS: please feel free to read my profile for more information.
$177 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hello, I am happy to help you with this project as it falls into my daily job functions, and i like new challenges. I am a Data and analytics consultant, so as a part of my job i am used to establish and discuss business rules with my clients and then translate them into code and process data accordingly with those rules. I created the tasks necessary to complete your project so that you are able to keep track of what stage the work is. Thanks in advance, Pedro Biscaia
$50 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hello. Thank you for this wonderful opportunity to work for you. I would like to take on this task with my efficient work ethic and responsibility. I look forward to hearing back from you and speaking to you in the future. Thank you!
$50 USD ndani ya siku 0
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
We have the ability, principles and enthusiasm of youth. Give us this opportunity, I'll make you satisfied
$45 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
As a new freelancer, I would like to prove myself and satisfy my client. This is a perfect opportunity to prove my skills and develop a track record for myself.
$40 USD ndani ya siku 2
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I am a fully experienced administrator, with experience in diary management and time-sheets. I am happy to complete this task and send the finished spreadsheet back to you within 3 days of receiving the work. I am used to working to strict deadlines and I have experience in working out hours in placements and similar for my students and senior colleagues, which is why I feel I can complete this job to a high standard with a short turnaround. This is something I am more than capable of providing with 100% accuracy for you. I have my European computer driving license (EDCL) so am proficient working across multiple spreadsheets.
$88 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya BRAZIL
Osasco, Brazil
5.0
41
Njia ya malipo imethibitishwa
Mwanachama tangu Nov 28, 2004

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.