View Single Post
  #1   Report Post  
benallen105 benallen105 is offline
Junior Member
 
Location: Vancouver
Posts: 8
Default Converting this raw data into something formulaic

Hi folks,

Been having real trouble sorting out a piece of data I'm working on, so I resorted to searching Google and I stumbled upon this forum! And what a great idea it is!

So, I've been tasked with converting some time/date data into a bell curve on Excel. Basically I need to take a months worth of data on a spreadsheet (albeit inputted with no formulas behind it - just completely bare text) and create something that shows the most popular time of day that people are using a specific piece of software. An example of a couple of lines of data is this:

2012-01-07 23:16:25 PST
2012-01-07 23:17:02 PST

That is all each line says. Think of that times by about 10,000 lines. I've got to convert that into a bell curve that makes sense.

So, anyone got any suggestions? I've got some Excel skills but I'm unfortunately no Guru!

Thanks :)