• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count and rearrange time in excel

C

coolkiran

Member
Hi All

I have a complex excel file, which contains swipe details.

I have attached sample file. i need to count the total time spent on each location, not getting any idea how we can do it.

Eg: Row 3 and Row 4 having time for "10TH FLR WORK-STATION" which is 1 min,
10TH FLR MAIN-ENT which is 5 min (Row 5 - Row 2), similarly i have for few days..

Is that possible.
 

Attachments

  • test file.xls
    22.5 KB · Views: 5
Hi ,

Did you check out the cell format I used ?

It is dd hh:mm ; if you change it to what ever other format you wish to use , the results are all correct.

Narayan
 
You must log in or register to reply here.
Back
Top