Publicar un concurso

Create Formula For Excel Spreadsheet to transpose cells and calculate time

Estado: Closed
Premio: $25
Propuestas recibidas: 3
Ganador: matheusbsl

Winner

Resumen del concurso

Hello I have a spreadsheet in a format that I want to automatically convert in another format in excel and calculate the total time.

The source will always be in the "Employee attendance" format and should be converted to the Proper Format workbook.

We should be able to copy new time data in the Employee Attendance format and the excel workbook Proper Format should be automatically generated.

Pay attention to the dates as there will be more and more dates added to the original sheet. So it has to work with an infinite amount of dates added.

Habilidades recomendadas

Excel

Winner

Publica un concurso similar

Comentarios del empleador

“Excellent work. Fast and accurate. I recommend”

algrim2011, United States.

Principales propuestas de este concurso

matheusbsl Brazil

0
juvigy Bulgaria

0
CarolinaCardoza Venezuela

0

Tablero de aclaración pública

nhicko07
- 5 años atrás
hi! please check my formula in #1..many thanks!
- 5 años atrás
1. nhicko07
  - 5 años atrás
  here is the link of the file: https://drive.google.com/file/d/1DpRBAk7wLdlns7PQsPQ-xdOujfu6xCdB/view?usp=sharing
  
  thanks!
  - 5 años atrás
lherreraz
- 5 años atrás
I am workin on this one! What is "Propper format"? is changing this -> 6:25 hours (from 4:48 PM to 11:13 PM) to this? -> 6:25
- 5 años atrás