EXCEL TIME/DATE

[marsss]

Hello, i did run around some time fonction in excel, but i can't find one to put date and time togheter in one cell.

data i got at the moment look like :

03/14/2005 00:52:08
03/14/2005 00:53:08
03/14/2005 00:54:08
03/14/2005 00:55:08
03/14/2005 00:56:08
03/14/2005 00:57:08

It s consider as texte at the moment. I want it to be as a date/time to generate a graphic to show some value over the time.

Any tip?

 

[SkipVought]

Hi,

You can enter date/time values in a single cell. Keep in mind that date/time values are just numbers. For instance, right now in Texas it's 38425.36072 which can be FORMATTED to DISPLAY any number of ways via Format/Cells/Number Tab.

If these are currently TEXT STRINGS, then you can CONVERT then to Date/Time values using the Date & Time Worksheet Function. So if your TEXT is in A1...
[tt]
=Date(MID(A1,7,4), left(A1,2), mid(A1, 4,2)&" "&Time(mid(A1,12,2),mid(A1,15,2),mid(A1,18,2))
[/tt]



Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[marsss]

Ok, i did remplace your &" "& by + to have a value like 38425.36072

Ok, i can generate a graphic showing my data over time setting date to time

but if my data go over couple day, is it possible to see on the graphic the full date + time instead that 38425.36072

Like :

5|
4|     
3|*   *
2|  *
1|___________
  2 2 2
  0 0 0
  0 0 0
  5 5 5
  / / /
  0 0 0
  1 1 1
  / / /
  0 0 0
  1 1 2
      
  0 0 0
  1 2 1
  : : :
  0 0 0
  1 1 1
  : : :
  0 0 0
  0 0 0

 

[marsss]

If i set filter like :

yyyy-mm-dd hh:mm:ss

it wont work, put all data of the same day togheter

 

[marsss]

Ok, i made it work, had to set filter to hh:mm:ss for the data, and set the date on the filter of the graphic.

 

[SkipVought]

Format the X-Axis as Date/Time

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}