Create Formula For Excel Spreadsheet to transpose cells and calculate time

  • Status: Closed
  • Prize: $25
  • Entries Received: 3
  • Winner: matheusbsl

Contest Brief

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.

Recommended Skills

Employer Feedback

“Excellent work. Fast and accurate. I recommend”

Profile image algrim2011, United States.

Top entries from this contest

View More Entries

Public Clarification Board

  • nhicko07
    nhicko07
    • 5 years ago

    hi! please check my formula in #1..many thanks!

    • 5 years ago
    1. nhicko07
      nhicko07
      • 5 years ago

      here is the link of the file: https://drive.google.com/file/d/1DpRBAk7wLdlns7PQsPQ-xdOujfu6xCdB/view?usp=sharing

      thanks!

      • 5 years ago
  • lherreraz
    lherreraz
    • 5 years ago

    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 years ago

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!