Closed

OBRC Time Calc Formula

I have an Excel sheet that is the result of a report in our Service software. I need to calculate two different elapsed times (arrival and complete). I have tried several formulas and calcualtions, to no avail...I get close, but not 100% correct, using such things as networkdays and networkdays.intl. Also, sometimes the service is same day (before midnight) and other times spans multiple days. Service can occur before or after operating hours, but elapsed time can only count 8am to 6pm.

We run 7 days per week, 8am to 6pm, wiht only 2 exceptions (Thanksgiving Day and Christmas day)

Review the attached spreadsheet.

I need to EXCLUDE 6pm to 8am from elapsed time hours

I need the elapsed time between column E and Column F into column K

I need the elapsed time between column E and column G into column L

I have used pen/paper to show results in column M and N to show you the desired result

Also, I need to be able to drag (or paste) the formula, as this report is run at least daily, and sometimes more, and the number of rows vary, depending on need.

formatting of any column can be adjusted to make your formula work easier...meaning split date/time into seperate columns, change date/time formatting, etc...

this report is variable, so the base premise I am shooting for is what is the formula....and then if I add/remove columns, what do I adjust in the formula to maintain the calculation.

Skills: Excel, Data Processing, Mathematics, Data Entry, Visual Basic

See more: time keeping calculation excel sheet, excel sheet time management, excel sheet real time stock bloomberg, read real time data currently opened excel sheet, excel formula call sheet, excel sheet scheduling software, programm windows open excel sheet specific time, time management excel sheet free, convert excel sheet small software, excel salary sheet software, excel formula function sheet, convert excel sheet software package, convert excel sheet software, real time nse data excel sheet, convert excel sheet software app, food cost formula excel sheet, school time table in excel sheet, food cost formula excel sheet download, food cost formula excel sheet download free

About the Employer:
( 0 reviews ) Portland, United States

Project ID: #32231255

21 freelancers are bidding on average $155 for this job

P0L

(492 Reviews)
8.0
(412 Reviews)
8.2
liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the More

$250 USD in 4 days
(97 Reviews)
7.8
(322 Reviews)
7.4
(227 Reviews)
7.0
daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power More

$70 USD in 1 day
(146 Reviews)
6.9
suyashdhoot

Hi I am a very experienced statistician, data scientist and developer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies More

$450 USD in 7 days
(102 Reviews)
7.0
(172 Reviews)
6.4
dfexcel

Hi, I have carefully reviewed the uploaded excel file and the instructions which you have listed meticulously. I will revert with the updated file with all the listed issues resolved, utilizing my expertise in excel. P More

$63 USD in 1 day
(24 Reviews)
6.5
charleslimnet

Hello I am a proficient chartered accountant (C.A.) in EXCEL and finance analysis. I have 18 years’ experience as a practicing CPA and 20 years’ experience as an academic researcher and analyst. I am passionate about t More

$200 USD in 7 days
(99 Reviews)
6.4
huzaifarizwan995

I am an accounting,STATS, economics, marketing and finance and excel expert with success in maintaining and organizing data, including dictionaries, metadata repositories, and cross-reference indexes across a broad ran More

$30 USD in 1 day
(23 Reviews)
4.7
(47 Reviews)
4.4
(25 Reviews)
4.0
varimaxanalytic

Hello! I am really interested in this job. I’m data scientist working remotely with various analytical companies. I’m offering best quality and highest performance at a price we are both comfortable with. I can compl More

$100 USD in 2 days
(3 Reviews)
3.6
IdealExpert

OBRC Time Calc Formula This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices. I have more More

$30 USD in 1 day
(5 Reviews)
2.5
BlessAccounts

Hello, I am qualified Chartered Accountant with more than 10 years of experience in accounting and finance. My profession involves me to work and play around with figures and calculations and I'm an Excel Guru. I have More

$250 USD in 7 days
(2 Reviews)
1.3
jimvandamn

This seems pretty straightforward. I already started writing the formula and could have it done in a couple hours.

$50 USD in 1 day
(1 Review)
0.6
(0 Reviews)
0.0
gracenatividad48

I have done data entry, transcription jobs before so doing a thing like this is very easy for me. Expect a quality work in just a matter of days.

$200 USD in 4 days
(0 Reviews)
0.0
Bhavinparmar02

Hi, I have read carefully your project description, I will summarize all points and will provide you with quality notes. I am a Data Analyst, I have Thourghly more than 5 years of experience in it. I will provide you q More

$150 USD in 3 days
(0 Reviews)
0.0