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.

Taidot: Excel, Tietojenkäsittely, Matematiikka, Tiedonsyöttö, Visual Basic

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Portland, United States

Projektin tunnus: #32231255

21 freelanceria on tarjonnut keskimäärin $155 tähän työhön


(492 arvostelua)
(412 arvostelua)

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 Lisää

$250 USD 4 päivässä
(97 arvostelua)
(322 arvostelua)
(227 arvostelua)

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 Lisää

$70 USD 1 päivässä
(146 arvostelua)

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 Lisää

$450 USD 7 päivässä
(102 arvostelua)
(172 arvostelua)

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 Lisää

$63 USD 1 päivässä
(24 arvostelua)

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 Lisää

$200 USD 7 päivässä
(99 arvostelua)

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 Lisää

$30 USD 1 päivässä
(23 arvostelua)
(47 arvostelua)
(25 arvostelua)

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 Lisää

$100 USD 2 päivässä
(3 arvostelua)

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 Lisää

$30 USD 1 päivässä
(5 arvostelua)

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 Lisää

$250 USD 7 päivässä
(2 arvostelua)

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

$50 USD 1 päivässä
(1 arvostelu)
(0 arvostelua)

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 4 päivässä
(0 arvostelua)

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 Lisää

$150 USD 3 päivässä
(0 arvostelua)