Excel Formulas

$10-30 AUD

Completed

Posted

over 9 years ago

$10-30 AUD

Paid on delivery

I need to make this excel roster spreadsheet automatically deduct 30 mins if the shift length is 5 hours or more. It currently deducts the 30 mins for some shifts that are 4.5 hours, but not all. It depends on the start/end time and i cant find out why the formula behaves differently for different times of day. This total shift time is then used to calculate a total number of hours for that line at the end of the week. The cells that do the calculating are hidden, i have left a section unhidden and highlighted so you can see what formulas are being used.

Data Entry

Data Processing

Excel

Project ID: 6741071

About the project

4 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

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:

@P0L

Hi there! I'm an excel expert and I'd like to help you with those formulas. I'll solve this within the next few minutes (already started). Update: I finished the job. Please send me a private message and I'll send you the file right away.

$20 AUD in 0 day

5.0

(6 reviews)

2.4

4 freelancers are bidding on average $26 AUD for this job

@dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.

$30 AUD in 2 days

5.0

(99 reviews)

5.9

@kher78

Hello, I can help you out with this right now. Time calculations sometimes act funny and I'm not sure why but I know how to get around them. I look forward to lending a hand.

$25 AUD in 0 day

4.9

(40 reviews)

4.8

@renesontiongson

Hi! excel automation is my masterpiece. It is my pleasure to help your project. Feel free to message me for final instruction so that I can start after you reward me. Thank you.

$30 AUD in 1 day