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

$30-250 USD

Dibatalkan

Dibuat

lebih dari 8 tahun yang lalu

$30-250 USD

Dibayar ketika dikirim

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.

ID Proyek: 8113829

Tentang proyek

3 proposal

Proyek remot

Aktif 9 tahun yang lalu

Ingin menghasilkan uang?

Alamat email

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda

Dapatkan bayaran atas pekerjaan Anda

Uraikan proposal Anda

Gratis mendaftar dan menawar pekerjaan

3 freelancer menawar dengan rata-rata $131 USD untuk pekerjaan ini

@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 dalam 2 hari

4,9

(291 ulasan)

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 dalam 1 hari