Encerrado

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.

Habilidades: Excel, Processamento de dados, Matemática, Processamento de Dados, Visual Basic

Veja mais: 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

Acerca do Empregador:
( 0 comentários ) Portland, United States

ID do Projeto: #32231255

21 freelancers estão ofertando em média $155 nesse trabalho

P0L

(492 Comentários)
8.0
(412 Comentários)
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 Mais

$250 USD in 4 dias
(97 Comentários)
7.8
(322 Comentários)
7.4
(227 Comentários)
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 Mais

$70 USD em 1 dia
(146 Comentários)
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 Mais

$450 USD in 7 dias
(102 Comentários)
7.0
(172 Comentários)
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 Mais

$63 USD em 1 dia
(24 Comentários)
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 Mais

$200 USD in 7 dias
(99 Comentários)
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 Mais

$30 USD em 1 dia
(23 Comentários)
4.7
(47 Comentários)
4.4
(25 Comentários)
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 Mais

$100 USD in 2 dias
(3 Comentários)
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 Mais

$30 USD em 1 dia
(5 Comentários)
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 Mais

$250 USD in 7 dias
(2 Comentários)
1.3
jimvandamn

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

$50 USD em 1 dia
(1 Comentário)
0.6
(0 Comentários)
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 dias
(0 Comentários)
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 Mais

$150 USD in 3 dias
(0 Comentários)
0.0