Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting daily data into weekly, monthly and yearly data | Excel Discussion (Misc queries) | |||
Converting Vertical Data into Horizontal Data | Excel Discussion (Misc queries) | |||
Formulaic range with CountIf | Excel Worksheet Functions | |||
Reformattign Data/Converting-Combinign Vertical Data to Horizontal | Excel Worksheet Functions | |||
converting continuous data into binary data | Excel Worksheet Functions |