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

$30-250 USD

Cancelado

Publicado

hace casi 9 años

$30-250 USD

Pagado a la entrega

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 del proyecto: 8113829

Información sobre el proyecto

3 propuestas

Proyecto remoto

Activo hace 9 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

3 freelancers están ofertando un promedio de $131 USD por este trabajo

@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 en 2 días

4,9

(291 comentarios)

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 en 1 día