LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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 :)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting daily data into weekly, monthly and yearly data CEGavinMcGrath Excel Discussion (Misc queries) 4 April 3rd 23 06:54 PM
Converting Vertical Data into Horizontal Data Kiley Excel Discussion (Misc queries) 1 March 29th 10 04:53 PM
Formulaic range with CountIf exoticdisease Excel Worksheet Functions 6 July 9th 09 12:36 PM
Reformattign Data/Converting-Combinign Vertical Data to Horizontal Tunderwood Excel Worksheet Functions 1 March 17th 08 04:20 PM
converting continuous data into binary data Asa_johannesen Excel Worksheet Functions 6 August 27th 07 10:12 PM


All times are GMT +1. The time now is 04:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"