Completed

Google Sheet Formulas & Reporting

Hi, I am looking for someone to add some formulas and reporting to a Google Sheet.

Please take a look at the video below, and then answer the questions.

. I have also included a link to the sheet below, so you can copy the Google Sheet and work on it.

IMPORTANT: please DO NOT bid until you look at the video and answered the following questions. I am looking for a long term partner with this.

01 - how will you add up all time and display it as - e.g - 5h 20m

02 - how will you increase other times as new records are entered

03 - how will you manage the 'Move' button

VIDEO

[login to view URL]

GOOGLE SHEET (please make a copy)

https://docs.google.com/spreadsheets/d/1VVyfriy5Mygp4ni42kW7iQl8WdNJiiTnjxhrSjRmE-M/edit#gid=1230130007

Skills: Excel, Data Entry, Data Processing, Javascript, Google Sheets

See more: automatic import data google docs google calendar, use google finance formulas excel, fund fact sheet client reporting provider, google analytics ecommerce reporting magento, make account google days, make frame google image results, make money google adword professional, make money google adwords cpm, make money google app engine, make money google backend code, seller net sheet formulas real estate, odesk google query financial reporting, google maps sql reporting, google spreadsheet formulas, fl new hire, fl new hire reporting, fl new hire reporting online, ios and google computer programers in sebring fl

About the Employer:
( 70 reviews ) Wexford, Ireland

Project ID: #24443729

Awarded to:

madhubv86

Answers to your questions: 1. Sum (all the rows), divide it by 1440 as it is minutes (24*60), and then formal the cell as custom format h" hour(s) and "m" minute(s)" - Result: if the sum is 110, the cell will display i More

€30 EUR in 2 days
(0 Reviews)
0.0

19 freelancers are bidding on average €34 for this job

BaNgan

Hello I can use the onChange trigger and dateFormat to display the custom date data Thanks Ngan Le

€75 EUR in 1 day
(356 Reviews)
7.5
royalcalif

I would like to discuss little bit more about the project for appropriate duration and cost as well. I assured that i have provide you 24/7 communication support during the project. Hi Mr. Employer, Basically the Goog More

€30 EUR in 1 day
(81 Reviews)
5.8
einnovention

ans1=js has a DOM tag for this Ans 2= we can make a loop for this purpose HTML offers navbtns for video movement :) we have more than 7 years of experience dear so you can trust us :) lets have a chat :) Best: Grewal

€60 EUR in 1 day
(13 Reviews)
5.4
saqibabbasi01993

Hi, What type of formulas you want to add in your excel file? Can we discuss the project particulars via PMB? Do you have any prefrences? If you want to get more detail about our services, visit our official website: More

€8 EUR in 1 day
(52 Reviews)
4.8
arnoldb

Hello, Hope you are doing amazing ! ! ! ! ! I am developer from Poland having more than 8 years professional experience in web design & development. I've read the details and I will add formulas and reporting to goo More

€80 EUR in 2 days
(5 Reviews)
4.9
Sabb97

Hi, I'm the right person for you. I have worked on similar projects to what you are looking for. I am punctual, dependable and highly professional. I'll be glad If you choose me. I can exceed your expectations. 1. Fi More

€10 EUR in 1 day
(3 Reviews)
2.6
Soikat96

Hello Sir, I am very much interested in working on your project.I have lots of experience in data typing, data entry, web research, database administration, ad posting, data research, data mining, data extracting, da More

€8 EUR in 7 days
(2 Reviews)
1.0
expertsol3

Hi Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requirements. We h More

€21 EUR in 7 days
(1 Review)
2.0
Shireenmirza

Hi, I have looked at your project in details and also saw attached video file.I am an expert in google sheets or Ms-Excel formulas and can solve your problems. I can do your tasks and provide you the better results in More

€25 EUR in 7 days
(0 Reviews)
0.0
R7027390071

I have worked in Base Functionality Process, device life cycle process, active directory and somehow networking part like CCNA, Cisco routers and Jupiter, accelerator device configurations, switches, hubs and VLAN Netw More

€130 EUR in 7 days
(0 Reviews)
0.0
julianabiasoto

Hi, I am new freelancer and a junior web developer, but I actually started programming with google sheets to improve the efficiency and the life of my husband's family business, they are not very prone to computers, so More

€55 EUR in 7 days
(0 Reviews)
0.0
aqeelsindhu80

I am an IT professional with an expertise in Excel. I have 5 years of experience working on Excel and have completed many projects successfully. I am skilled in Data Entry, Data analysis and data processing. I always c More

€15 EUR in 4 days
(0 Reviews)
0.0
AnjatantelyAina

I am interested in your offer. I am the best candidate for this project. I am a developer from Madagascar. I have 5 years experiences of Javascript. I respect the deadline I am motivated and very professional I am an e More

€10 EUR in 5 days
(0 Reviews)
0.0
€23 EUR in 1 day
(0 Reviews)
0.0
sainisairy

hi everyone i am [login to view URL] Abbas work new freelance. i can work graphic designing and embroidry punching design.

€19 EUR in 7 days
(0 Reviews)
0.0
abrahamhassan07

I'd be able to deliver this with excellence. This can be a start of our great business relationship. I work efficiently even more under pressure.

€14 EUR in 7 days
(0 Reviews)
0.0
krguddu61

I am interested in this project I have a good typing speed in word or excel I work at the my team and I sure summit you project on time

€19 EUR in 3 days
(0 Reviews)
0.0
pradeepperelly91

I have FIVE years experience in this field of MS Office (PGDCA). I will do it, assign the task and get it done. I have been certified from udemy.

€18 EUR in 3 days
(0 Reviews)
0.0