Data Formulas/Macro (Finding Time Between Durations) - open to bidding

$30-250 USD

Zrušeno

Zveřejněno

skoro před 9 roky

$30-250 USD

Zaplaceno při doručení

Hi, Please review attached document. I need help finding a formula/macro that will tell me how long the person is sleeping (In column D: 0 = not asleep, 1 = asleep), and the amount of time it takes a person to fall asleep (sum between the first 1 of the lying in column C and first 1 of sleeping column D). The problem is that the document has about 7 days worth of data, capturing each minute. Thus, the formula/macro must also be able to define sleep and time taken to fall asleep (accounting for awakenings) during each 24 hour period.

IČ projektu: 8113829

O projektu

3 nabídky

Vzdálený projekt

Aktivní před 9 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

3 freelanceři nabízejí v průměru $131 USD za tuto práci

@Teloquence

Consider it done. Check my past reviews for your reference eagerly looking forward for your reply so that I can start with the implementation

$242 USD v 2 dnech

4,9

(291 recenze)

7,4

@priyal1997

Dear Sir/Madam, I'm happy to help you on this task. I'm an expert in advanced excel features and have developed lots of such models for various businesses. If you are comfortable with all above along with my ratings and reputations, please send me the information to confirm. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards Priyal

$50 USD v 1 dni