# Find the most valueable hours in a day... (MS EXCEL)

We have a series of values, which describe the "value" of 15 minutes in consecutive 15-min-intervalls, as follows:

from - to value

00:00h - 00:14h 5

00:15h - 00:29h 9

00:30h - 00:44h 11

00:45h - 00:59h 8

01:00h - 01:14h 3

01:15h - 01:29h 88

etc.

The value of 00:00h - 00:59h is 5+9+11+8=33

The value of 00:15h - 01:14h is 9+11+8+3=31

The value of 00:30h - 01:29h is 11+8+3+88=110

etc.

The task is to find the x most valuable hours (containing 4 consecutive 15-minute-values) of the entire series of data.

*Typically*, there are 48 values, representing 12 hours (see attached example) and we need to find the five most valuable hours (x=5).

*Note1*: The hour can start at *any* of the 15min-values, like one hour 03:15h - 04:14h or one hour 02:45h - 03:44h

*Note2*: The most valuable hours may contain every 15-min-value of the series only once (no double usage, no overlapping of the most valueable hours)

The table is in MS EXCEL. So formulas, a spread-sheet, etc shall be provided as a result. An example is provided as an attachment.

Beceriler: Excel, Veri Girişi, Veri İşleme

İşveren Hakkında:
( 14 değerlendirme ) Villnachern, Switzerland

Proje NO: #28558128

## Seçilen:

(310 Değerlendirme)
7.1
klakshana20

Hey there, I went through all the details you gave and the spread sheet. I can assist you to find most 5 valuable hours with 4 consecutive 15-minute-values in a day as I'm good in IQ. PS: I've been working as a Mathem Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% EUR
(3 Değerlendirme)
1.4

## Bu iş için 13 freelancer ortalamada €23 teklif veriyor

(229 Değerlendirme)
6.6
hamidr2020

Hello, I have read your project details and I am interested in this project. A professional, qualified and experienced analyst who is expert in numerical, verbal and reasoning. I am sure my experience and skills will Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(18 Değerlendirme)
4.4

Hello ! How do you do??? I have checked the project details; I am expert in ms excel. Contact me so we can discuss about it before you award the job. Looking forward to work with you. Thanks.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(28 Değerlendirme)
3.4
Rinkup0

Hi, I'm energetic, driven and attentive Virtual assistant I am always looking to work long term and provide you quality work. Please review my profile for Web and Data entry, Excel projects https://www.freelancer. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(6 Değerlendirme)
2.9
allenn55

Hello there With a lot of experience high skills in excell and math i am confident of being best person for completing your tasks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(20 Değerlendirme)
2.7
Buddhininiro123

Hello, I am a 4th year medical undergraduate (MBBS) from Sri Lanka. i have extensive knowledge in research work, academic writing, report writing, data analysis. I have knowledge in searching through online medical da Daha Fazla

€10 EUR in 2 gün içinde
(0 Değerlendirme)
0.0
nasimA23746

Hi Buddy, If you are looking for a genius for this project, Then you are reading the right one. Over the last 1 years, I have been working as a Data entry, Data analysis, PDF/JPG to Word/Excel as well. I have higher ex Daha Fazla

€25 EUR in 4 gün içinde
(0 Değerlendirme)
0.0
bouz0ch

my work is very serious and dynamic, I am punctual and fast I can very well help you in this job I have a lot of experience in the data entry and accounting marketing too, and all type of windows software, I would like Daha Fazla

€19 EUR in 7 gün içinde
(0 Değerlendirme)
0.0
Shanjooritta

Good day I am willing to do this job because I believe that i can complete your project within the time given and also with a reasonable budget. Being a professional data entry knowledge, I am responsible for manually Daha Fazla

€18 EUR in 6 gün içinde
(0 Değerlendirme)
0.0
Ajay1911

Dear Employer, I have reviewed your project details that seems to be great and I can help you out in completing that.I am a passionate PHP Developer with wide experience in Web Designing and Development. I will provide Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.0
dipta139628

Hello, I am an engineer and expert in MS Excel Formula. I have read the problem and I am sure I can do it. I will need at most 3 Hours time to deliver the solution correctly. You can check my portfolio items for some Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(0 Değerlendirme)
0.4