Posto një konkurs

Create Formula For Excel Spreadsheet to transpose cells and calculate time

Statusi: Closed
Çmimi: $25
Kandidaturat e marra: 3
Fituesi: matheusbsl

Winner

Përmbledhja e konkursit

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.

Aftësi të rekomanduara

Excel

Winner

Posto një konkurs si ky

Vlerёsimi i punёdhёnёsit

“Excellent work. Fast and accurate. I recommend”

algrim2011, United States.

Punimet mё tё mira nga ky konkurs

matheusbsl Brazil

0
juvigy Bulgaria

0
CarolinaCardoza Venezuela

0

Këndi publik i sqarimeve

nhicko07
- 5 vite më parë
hi! please check my formula in #1..many thanks!
- 5 vite më parë
1. nhicko07
  - 5 vite më parë
  here is the link of the file: https://drive.google.com/file/d/1DpRBAk7wLdlns7PQsPQ-xdOujfu6xCdB/view?usp=sharing
  
  thanks!
  - 5 vite më parë
lherreraz
- 5 vite më parë
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 vite më parë