Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Convert Times To Text As Military Times
Started 1 month, 2 weeks ago by maceyz
I have a long column of telephone call times . The cell shows time in the format of 17:29:28 but when I highlight the cell, it shows the format of 5:29:28 PM in the formula bar. When I try to copy these cells or export them, they immediately turn to the serial version of 0.728796296. I can easily get these cells to turn to the serial number 0.728796296 by formatting the cells ...
Site: Excel Help/VBA Help:  Excel Help/VBA Help: - site profile
Forum: Excel Help  Excel Help - forum profile
Total authors: 2 authors
Total thread posts: 5 posts
Thread activity: no new posts during last week
Domain info for: ozgrid.com

Other posts in this thread:

Dave Hawley replied 1 month, 2 weeks ago
=TEXT(E2,"h:mm:ss") copied down. Then copy paste special as values.
Size: 1,778 bytes
Customize:  Customize "<b>Reply 1</b>: Convert Times To Text As Military Times :: Excel Help :: Excel Help/VBA Help:"

Dave Hawley replied 1 month, 2 weeks ago
Quote: Originally Posted by maceyz Yup, that did it! Wow, I must have wasted 10-12 hours searching for a solution. Thank you! Answers are like lost things , they are always in the last place you look
Size: 3,947 bytes
Customize:  Customize "<b>Reply 2</b>: Convert Times To Text As Military Times :: Excel Help :: Excel Help/VBA Help:"

maceyz replied 1 month, 2 weeks ago
Yup, that did it! Wow, I must have wasted 10-12 hours searching for a solution. Thank you!
Size: 2,324 bytes
Customize:  Customize "<b>Reply 3</b>: Convert Times To Text As Military Times :: Excel Help :: Excel Help/VBA Help:"

maceyz replied 1 month, 2 weeks ago
Best dollar ever spent!
Size: 23 bytes
Customize:  Customize "<b>Reply 4</b>: Convert Times To Text As Military Times :: Excel Help :: Excel Help/VBA Help:"

 

Top contributing authors

Name
Posts
maceyz
3
user's latest post:
Convert Times To Text As...
Published (2009-11-03 02:38:00)
Yup, that did it! Wow, I must have wasted 10-12 hours searching for a solution. Thank you!
Dave Hawley
2
user's latest post:
Convert Times To Text As...
Published (2009-11-03 02:38:00)
=TEXT(E2,&quot;h:mm:ss&quot;) copied down. Then copy paste special as values.

Related threads on "Excel Help/VBA Help:":

Convert Selection Text to Lower Case  Excel Help/VBA Help: - site profile Excel Help - forum profile Convert Selection Text to Lower Case
Convert Selection Text to Lower Case
Hyperlink email convert to text not working  Excel Help/VBA Help: - site profile Excel Help - forum profile Hyperlink email convert to text not working
Hyperlink email convert to text not working
Convert A Text Field To Numeric On Import  Excel Help/VBA Help: - site profile Excel Help - forum profile Convert A Text Field To Numeric On Import
Convert A Text Field To Numeric On Import
Convert Imported Text File For Calculations  Excel Help/VBA Help: - site profile Excel Help - forum profile Convert Imported Text File For Calculations
Convert Imported Text File For Calculations
Convert Text Times In 1 Cell  Excel Help/VBA Help: - site profile Excel Help - forum profile Convert Text Times In 1 Cell
Convert Text Times In 1 Cell
Convert Decimal Times To True Times In Multiple Workbooks  Excel Help/VBA Help: - site profile HIRE HELP - forum profile Convert Decimal Times To True Times In Multiple Workbooks
Convert Decimal Times To True Times In Multiple Workbooks
Convert Standard Time In Military Time  Excel Help/VBA Help: - site profile Excel Help - forum profile Convert Standard Time In Military Time
Convert Standard Time In Military Time
Calculate Military Times Without Colon  Excel Help/VBA Help: - site profile Excel Help - forum profile Calculate Military Times Without Colon
Calculate Military Times Without Colon
Convert Text To Number in Lookup Formula  Excel Help/VBA Help: - site profile Excel Help - forum profile Convert Text To Number in Lookup Formula
Convert Text To Number in Lookup Formula
Convert text to long number macro  Excel Help/VBA Help: - site profile Excel Help - forum profile Convert text to long number macro
Convert text to long number macro

Related threads on other sites:

Flex Tip: ctrl+shft+x -&gt; convert selected text to...  Twitter / ashier - site profile ashier - forum profile Flex Tip: ctrl+shft+x -&gt; convert selected text to uppercase ctrl+shft+y -&gt; convert selected text to lowecase 9:58 PM Jun 21st from Echofon
Flex Tip: ctrl+shft+x -&gt; convert selected text to uppercase ctrl+shft+y -&gt; convert selected text to lowecase 9:58 PM Jun 21st from Echofon
Convert Text to an Image: I need to convert some text in...  Twitter / edugeekuk - site profile EduGeekUK - forum profile Convert Text to an Image: I need to convert some text in a table into an image: Example: I have the text ".. http://tinyurl.com/a8qvlg about 12 hours ago from twitterfeed
Convert Text to an Image: I need to convert some text in a table into an image: Example: I have the text ".. http://tinyurl.com/a8qvlg about 12 hours ago from twitterfeed
HearWho: Convert Text to Speech: Small web service that...  Twitter / MakeUseOf - site profile Aibek - forum profile HearWho: Convert Text to Speech: Small web service that lets you convert any text to MP3 audio for use .. http://tinyurl.com/6a93hd 11:55 PM August 02, 2008 from twitterfeed
HearWho: Convert Text to Speech: Small web service that lets you convert any text to MP3 audio for use .. http://tinyurl.com/6a93hd 11:55 PM August 02, 2008 from twitterfeed
Just realized: to use gaussian blur on text in...  Twitter / kdeas - site profile Katrina - forum profile Just realized: to use gaussian blur on text in illustrator you need to convert the text into a bitmap to make it look good for print! 5:57 AM May 15th from web
Just realized: to use gaussian blur on text in illustrator you need to convert the text into a bitmap to make it look good for print! 5:57 AM May 15th from web
Convert to text in a text box in microsoft.public.access  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Convert to text in a text box in microsoft.public.access
Convert to text in a text box in microsoft.public.access
Convert hostname text file to IP text file in...  Discussions in microsoft.public.scripting.vbscript - site profile microsoft.public.scripting.vbscript - forum profile Convert hostname text file to IP text file in microsoft.public.scripting.vbscript
Convert hostname text file to IP text file in microsoft.public.scripting.vbscript
How to read selected text from text file and how to...  CodeProject: Discussion Boards. Free source code and programming help - site profile C# - forum profile How to read selected text from text file and how to convert selected text into msacess database
How to read selected text from text file and how to convert selected text into msacess database
Go listen to this: you can convert written text into...  Twitter / chefkeem - site profile Chef Keem - forum profile Go listen to this: you can convert written text into spoken text (other languages too) http://www.spokentext.net/r... 8:09 PM Jan 9th from twhirl
Go listen to this: you can convert written text into spoken text (other languages too) http://www.spokentext.net/r... 8:09 PM Jan 9th from twhirl
Convert handwritten text into typed text in windwes...  Technology Questions: Desktops, Notebooks, Tablet PCs, UMPCs, MID, and Mobile PCs - A Tablet PC, UMPC, and Small Form Factor Mobile PC Resource - site profile Windows XP Tablet PC Newsgroup - forum profile Convert handwritten text into typed text in windwes tablet PC - Technology Questions: Desktops, Notebooks, Tablet PCs, UMPCs, MID, and Mobile PCs
Convert handwritten text into typed text in windwes tablet PC - Technology Questions: Desktops, Notebooks, Tablet PCs, UMPCs, MID, and Mobile PCs
Convert to Text/Convert to Number  MrExcel Message Board - site profile Excel Questions - forum profile Convert to Text/Convert to Number
Convert to Text/Convert to Number
Thread profile page for "Convert Times To Text As Military Times" on http://www.ozgrid.com. This report page is a snippet summary view from a single thread "Convert Times To Text As Military Times", located on the Message Board at http://www.ozgrid.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity