Thanks Koi, it was really damn helpfull...I was able to do the calculation based on your formulas.
Kudos!!! Cant thank you enough!
Thanks Narayan!
Chaitra
Hi Narayan,
Thanks for such quick response.
I have explained everything in the attached excel sheet.
Kindly take a look and let me know how do i do that.
http://www.2shared.com/file/x-LGhzqr/sample-3.html
Thanks a lot for all the help. Really appreciate it...
Also seeing what Deb has given , wanna inform that i wanna map the ticket time with the install time, not only the number of tickets.
That is for ex:
Install time is 2012-10-31T21:08:08
2 tickets were created by that unique ID with time
2012-10-31T22:09:43 and 2012-11-07T13:15:52, then i...
Thanks a lot Narayan and Deb for the posts.
1. Your data is in 8 columns , column A through column H , is this correct ?
-Yes, right
2. The entries in column A are all unique ; there will be no duplicates.
-Yes , right
3. The counts of tickets , in column C - will it be entered , or is...
Hi All,
I am new to this forum and my first post.
I have a complicated task which i need to complete in excel.
I have many columns
A: Unique ID B:Install Time, C:Ticket 1 Creation Time, D:Ticket 2 creation time.E:Ticket 3 Creation time so on...
I need to get something like below
15 days...