IPB
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

MS Excel, Cell format issues
djellison
post Nov 12 2006, 06:33 PM
Post #1


Founder
****

Group: Chairman
Posts: 14457
Joined: 8-February 04
Member No.: 1
This is a date/time format I often come across when looking a spaceflight related data from places such as the PDS or the radiation / relay logs...
2004-01-02T19:15:38 or 2006-315T23:03:23.0(one using yyyy-mm-dd and one using yyyy-ddd etc )

Try as I might, I can't get Excel to 'read' these properly, even using my own custom cell format type as yyyy-ddd"T"hh:mm:ss.s

Any pointers?

Doug
Go to the top of the page
 
+Quote Post
 
 Start new topic
Replies
djellison
post Nov 12 2006, 08:36 PM
Post #2


Founder
****

Group: Chairman
Posts: 14457
Joined: 8-February 04
Member No.: 1
Wow - I'll try these later ohmy.gif

Doug
Go to the top of the page
 
+Quote Post

Posts in this topic
- djellison   MS Excel   Nov 12 2006, 06:33 PM
- - helvick   When I come across issues like this I usually ...   Nov 12 2006, 06:54 PM
- - brianc   Doug Copy your Date / Time string into Column A ...   Nov 12 2006, 07:43 PM
|- - Leither   Doug For the second format e.g 2006-315T23:03:23...   Nov 12 2006, 10:05 PM
- - djellison   Wow - I'll try these later Doug   Nov 12 2006, 08:36 PM
- - helvick   The problem with dealing with potentially variable...   Nov 12 2006, 10:31 PM
- - nprev   Sure glad to see that there are some Excel whizzes...   Nov 12 2006, 10:38 PM

« Next Oldest · Chit Chat · Next Newest »
 

Reply to this topicStart new topic

 

Display Mode: Switch to: Standard · Switch to: Linear+ · Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Lo-Fi Version Time is now: 17th December 2024 - 07:42 AM
Powered By IP.Board © 2024  IPS, Inc.
RULES AND GUIDELINES
Please read the Forum Rules and Guidelines before posting.

IMAGE COPYRIGHT
Images posted on UnmannedSpaceflight.com may be copyrighted. Do not reproduce without permission. Read here for further information on space images and copyright.

 OPINIONS AND MODERATION
Opinions expressed on UnmannedSpaceflight.com are those of the individual posters and do not necessarily reflect the opinions of UnmannedSpaceflight.com or The Planetary Society. The all-volunteer UnmannedSpaceflight.com moderation team is wholly independent of The Planetary Society. The Planetary Society has no influence over decisions made by the UnmannedSpaceflight.com moderators.		 SUPPORT THE FORUM
Unmannedspaceflight.com is funded by the Planetary Society. Please consider supporting our work and many other projects by donating to the Society or becoming a member.