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

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

Skills: Copy Typing, Data Entry, Data Processing, Excel

See more: employee time clock app, employee time clock software, employee time tracking app free, harvest, tsheets, web based time clock, free online timesheets for employees, time clock app with gps, part time home based job housewife, want send 50000 emails day, calculate estimated time complete project, send million emails day, send 2000 emails day, need send 5000 emails day, 1000 emails day, reliable part time home based jobs, spreadsheet track time deliveries, php calculate shipping time, server send 100000 emails day, send thousand emails day

About the Employer:
( 41 reviews ) Osasco, Brazil

Project ID: #18868762

Awarded to:


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 res More

$100 USD in 3 days
(102 Reviews)

22 freelancers are bidding on average $111 for this job


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 More

$50 USD in 0 days
(194 Reviews)

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 More

$50 USD in 1 day
(86 Reviews)

Hi, - Could I use Google Spreadsheet to copy the content the first sheet content and generate the 2nd sheet? - I can take advantage of the Google Apps script to automatically calculate the time Thanks Ngan Le

$155 USD in 3 days
(12 Reviews)

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 mini More

$80 USD in 3 days
(12 Reviews)

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 g More

$150 USD in 2 days
(13 Reviews)

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 More

$170 USD in 5 days
(2 Reviews)

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 thi More

$111 USD in 3 days
(16 Reviews)

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 embrac More

$100 USD in 3 days
(10 Reviews)

I am accurate, quick, and trustworthy in data entry. Please contact me if you are interested. Thank you!

$55 USD in 3 days
(1 Review)

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 k More

$30 USD in 1 day
(4 Reviews)

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 in 2 days
(0 Reviews)

We have the ability, principles and enthusiasm of youth. Give us this opportunity, I'll make you satisfied

$45 USD in 3 days
(0 Reviews)

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 fut More

$50 USD in 0 days
(0 Reviews)

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 respon More

$55 USD in 1 day
(0 Reviews)

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 More

$50 USD in 1 day
(0 Reviews)

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 A More

$177 USD in 1 day
(0 Reviews)

I am an expert in Microsoft Excel, with experience in banks and financial services. I can do everything for you in Excel and also in Access. You can trust in me in this project, I can calculate what you want. For mo More

$166 USD in 1 day
(0 Reviews)

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 More

$133 USD in 3 days
(0 Reviews)

I very keen to details and knowledgeable in Excel. I know I am a new freelancer but I capable to do the job.

$555 USD in 10 days
(0 Reviews)

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 in 2 days
(0 Reviews)