Find Jobs
Hire Freelancers

calculate working hours in google sheet from IFTTT Data

€8-30 EUR

In Progress
Posted over 4 years ago

€8-30 EUR

Paid on delivery
I collect timestamps for when I arrive at work and when I leave work. The purpose is to calculate working hours automatically. The timestamp format is like this example: Raw Data February 05, 2018 at 08:38AM Left location February 06, 2018 at 08:19AM Arrived at location February 08, 2018 at 04:34PM Left location February 09, 2018 at 07:14AM Arrived at location February 13, 2018 at 07:18AM Arrived at location February 13, 2018 at 04:46PM Left location February 14, 2018 at 09:26AM Left location February 15, 2018 at 07:23AM Arrived at location February 16, 2018 at 07:45AM Arrived at location February 19, 2018 at 07:30AM Arrived at location February 20, 2018 at 08:57AM Arrived at location February 21, 2018 at 07:25AM Arrived at location February 23, 2018 at 08:21AM Arrived at location February 23, 2018 at 02:22PM Left location February 25, 2018 at 09:34AM Left location February 25, 2018 at 12:56PM Left location February 25, 2018 at 09:33AM Arrived at location February 25, 2018 at 12:54PM Arrived at location February 26, 2018 at 04:42PM Left location Some days, several timestamps occur, as seen Feb 25. To sort out, these rules shall be used: 1. If it is obvious that I left the location and returned at the same day: deduct the absence time from working hours. Mark this day's result in green. 2. If - as Feb 25 - this is not obvious, the earliest arrival and latest departure times shall be calculated with, ignore other timestamps as faulty. Mark this day's result in orange. 3. If one timestamp is missing for one day - either arrive or leave - replace with arrive 07:32 and leave 17:07. Mark this day's result in red. 4. If both timestamps are missing - then this was no working day. The raw data tab in the google sheet shall be left untouched. All calculations shall be inserted in a new tab. If java script / google apps script is used, the code shall be inside the document, commented and pretty. But standard google sheets commands are preferred. Google sheet: [login to view URL]
Project ID: 21240446

About the project

6 proposals
Remote project
Active 5 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
I have an experience of 10yrs in ms office, can do your work easily and with 100% accuracy. I am currently working in deccan Iservices Pvt Ltd.
€8 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
6 freelancers are bidding on average €31 EUR for this job
User Avatar
Hi, I am ready to start right away. I'm an expert in Excel I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many projects like this. Can you send me a message? Then we can discuss the details. Regards, Reza
€30 EUR in 1 day
4.7 (17 reviews)
4.0
4.0
User Avatar
Hello Sir/Madam I have read your task carefully and can do as described. Kindly do message for further discussion. I shall be happy to hear from you. Have a great day Thank you
€19 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am perfect for your job because i have previous work experience and know the importance of time maintaining and work value.
€9 EUR in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWEDEN
Lund, Sweden
5.0
3
Payment method verified
Member since Jul 4, 2016

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.