Excel expert to split overall timeframe into hourly contributions

Selesai Dipasang 6 tahun yang lalu Dibayar saat pengiriman
Selesai Dibayar saat pengiriman

Need excel formula to process multiple timeframes and split them into hourly contributions. The requirement is to determine the number of minutes within each hour that the timeframe covers. See example below. Start and Stop time will be known, formulas required to calculate minute contribution per hour. In the first example, for the timeframe 07:12 (start) to 09:18 (Stop), 48 minutes are in the 07:00 to 08:00 timeframe, 60 minutes in the 08:00 to 09:00 timeframe and 18 minutes in the 09:00 to 10:00 timeframe.

Timeframe Hourly Contributions

Start Stop 7:00 8:00 9:00 10:00

7:12 9:18 0:48 1:00 0:18 0:00

7:20 7:48 0:28 0:00 0:00 0:00

8:20 9:10 0:00 0:40 0:10 0:00

I need the ability to process multiple start-stop times.

Excel

ID Proyek: #16530533

Tentang proyek

46 proposal Proyek online Aktif 6 tahun yang lalu

Diberikan kepada:

ShaunKleinOnline

Hi there, Your project is very interesting and I think given my experience with this type of work that I would make a great fit. I have over 15 years of corporate experience working in Excel creating advanced automa Lebih banyak

$90 USD dalam 3 hari
(92 Ulasan)
6.6

46 freelancer rata-rata menawar $92 untuk pekerjaan ini

schoudhary1553

Hi there..... Warm Greetings We came along with your request for split overall timeframe into hourly contributions and we reviewed your project description. We'd like to help you with confidence and satisfying re Lebih banyak

$180 USD dalam 3 hari
(306 Ulasan)
7.9
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 USD dalam 3 hari
(325 Ulasan)
7.3
priyal1997

Dear Sir/Madam, As one of the trusted excel experts in this site, I;m happy to help you on this task. Please refer my profile to see my qualifications, experience and reliability, and if you are comfortable with thos Lebih banyak

$60 USD dalam 0 hari
(187 Ulasan)
6.8
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twelve excel vba projects in the past three months. Willing to take up your project. Thank you, Regards.

$45 USD dalam 0 hari
(106 Ulasan)
6.3
best4best

I am an Excel expert and can create an easy to use sheet for this timeframe split timings calculations.

$100 USD dalam 2 hari
(135 Ulasan)
6.3
supper5guy

Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can dev Lebih banyak

$60 USD dalam 3 hari
(82 Ulasan)
5.8
aubrey03

I am an Excel specialist. I am confident that I csn create the formula you need and if necessary I can also create a macro as per your requirements.

$30 USD dalam 1 hari
(121 Ulasan)
5.9
sorinacho88

Hello, I can create a macro that will run exactly as described and you can have multiple start-stop. You will just need to press a button. Nothing else. Please open a chat with me if you are interested. Kind Lebih banyak

$60 USD dalam 1 hari
(54 Ulasan)
5.2
afenache

Hi, I have over five years experience in using Excel at an advanced level (formulas, pivot table, macros, automatic calculation sheets) as an Industrial Engineer at Michelin. I am always keen to improve my work quali Lebih banyak

$70 USD dalam 1 hari
(22 Ulasan)
5.3
alembaptista

I have a lot experience in Excel and I can help you in this field. Thank for the opportunity.

$111 USD dalam 5 hari
(12 Ulasan)
4.7
massm90s

Hi there, I can do it right away, if you send me the file. (Before awarding me) Drop me a line, I'm online right now. I just need to know how many splits do you need. Best, M.Sijarrey.

$30 USD dalam 1 hari
(24 Ulasan)
4.2
gsanggara

Dear Sir/Madam, My name is Angga, I'm full-time freelancer. With my time availability I'm guaranteed quality of work with 100% accuracy will be delivered timely. My client's are happy with my work quality and keeping Lebih banyak

$70 USD dalam 1 hari
(26 Ulasan)
4.2
ongskjason

A proposal has not yet been provided

$60 USD dalam 1 hari
(7 Ulasan)
3.8
RenPerera

A proposal has not yet been provided

$30 USD dalam 2 hari
(8 Ulasan)
3.3
nanda1208

I think I can help you on your project. I believe that I can solve your project with VBA or formulas, which you prefer. Feel free to contact me to discuss any further details, my bid and deadlines. Best regards.

$30 USD dalam 1 hari
(14 Ulasan)
3.4
rhodelta

Experienced Excel/Word user based in Brisbane, Australia, with office and technical background. Good with maths, spreadsheet functions, and macros. Native English speaker fluent in US and UK English. .

$120 USD dalam 4 hari
(5 Ulasan)
2.6
FD4CAST

This is actually quite easy using VBA / A macro rather than a nested Excel formula. VBA will also allow you to process an infinite number of time gaps rather than worrying about copying a formula down a sheet. The proc Lebih banyak

$55 USD dalam 1 hari
(3 Ulasan)
1.9
cristiancpinto

Hello, I'm a reporting analysts at a contact center with timeframes of 15 to 30 minutes, I can help you with this formula and I will build you a pivot table to easily control de total time by every tineframe.

$55 USD dalam 3 hari
(1 Ulasan)
1.0
sro59ed93e151c5b

A proposal has not yet been provided

$30 USD dalam 2 hari
(2 Ulasan)
0.2
sumithpaul

Have been working as reporting analyst from past 5 years. Am using excel from past 5 years. i can complete the task in given time limit.

$155 USD dalam 3 hari
(0 Ulasan)
0.0