Kapalı

Help with Google Sheets formula

I was reaching out for some assistance on some formula building for a Google Spreadsheet. I manage a group of drivers who have to stay within DOT regulations of 70 working hours in a rolling 8 day period. I wanted to create the spreadsheet to total the hours for each driver within the eight day period, flag the driver if their total comes within 8 hours of violation, and restart the "clock" (sum of hours) if the driver does not accumulate hours for any day within the 8 rolling days.

Beceriler: Google Sheets

Daha fazlasını gör: google sheets help, google sheets formula, google sheets autofill formula, google sheets filter custom formula, google sheets find and replace formula, google sheets hyperlink formula, google sheets timesheet formula, google sheets time clock, google sheets clock in and out, google sheets array formula examples, google sheets array formula vlookup, google sheets array formula filter, google sheets array formula if, google sheets array formula, google sheets formula builder, convert google sheets formula to excel, how to lock a cell value in google sheets formula, google sheets - add days to date, google sheets subtract days from date, google sheets formula parse error

İşveren Hakkında:
( 0 değerlendirme ) Los Angeles, United States

Proje NO: #28200776

Bu iş için 13 freelancer ortalamada $107 teklif veriyor

tushchak0716

Hi greetings from Tushar!! I am interested in taking up your project of creating formula to calculate the total working hours of your drivers. I have hands on experience of working with google app script, google sheet Daha Fazla

$110 USD in 2 gün içinde
(5 Değerlendirme)
4.4
P0L

(10 Değerlendirme)
4.5
(3 Değerlendirme)
4.2
SeanJacobFox

Hello I am an English software developer. I am currently working on a Google Sheet project which manages and logs drivers' hours. I know how to implement the functions you request so I can do it in 1 day easily. I fre Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(8 Değerlendirme)
3.7
(3 Değerlendirme)
3.2
agmahran

Hi! My name is Ayman Mahran. I'm a programmer and a web developer. I have worked on many projects that involved using Google Sheets, Script, and API. I believe I'll be able to help you with this task. If you're interes Daha Fazla

$55 USD in 2 gün içinde
(3 Değerlendirme)
3.4
nikitalupinos1

Hi, I can Help you with this job, I have some experiences in google sheet. I can show you my past job. You can see the following.. [login to view URL] Daha Fazla

$180 USD in 3 gün içinde
(2 Değerlendirme)
2.9
(2 Değerlendirme)
2.8
datakillers

Hi,I am an Excel Expert with Professional experience working with Excel. I have more than 10 year experince with excel. Complete a lot of jobs on Freelancer with highly satisfaction of client. I believe I can do a grea Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)
2.5
IgeS

Hi there, Need a formula in Google Sheet that will help you evaluate the eight-day work hours of drivers? Please message me and give me a view of the sheet thus we can check whether it need a built-in formula or apps Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
2.5
sanjaysharma3480

Hi! Hope to find you doing great! I have rich experience in automation in google sheets and excel using inbuilt, customized functions and google app script. So, you want me to get the total hours worked by each driver Daha Fazla

$160 USD in 2 gün içinde
(2 Değerlendirme)
2.2
(3 Değerlendirme)
2.1
abdsalamamir

Hi! I believe I can provide the necessary service you require. Backed with 5 years experience in this industry, the accuracy of entered data, quick turnaround, and the fluency of the presented data are my main focus in Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0