Question #15068189

Converting time stamp to text in Excel?

How do convert a time stamp with the format HH:MM:SS to text in Excel? for example- if I have 10:42:00 and reformat to text I get 0.445833333333333. Is there a way to keep it as 10:42:00?

2017-05-02 04:57:51
first

1

last

TELL US , if you have any answer

Back to HOME
Sponsored ads
TAG cloud
Converting Excel convert format HH MM SS Excel example 10 42 00 reformat 0 445833333333333 10 42 00 0

There is NEVER a problem, ONLY a challange!

The helpinganswers.com is a free-to-use knowledgebase.
  The helpinganswers.com was started on: 02.07.2010.
  It's free to register. Once you are a registered user, you can ask questions, or answer them.
  (Unless registration you can just answer the questions anonymously)
  Only english!!! Questions and answers in other languages will be deleted!!

Cheers: the PixelFighters

  Contact: support@helpinganswers.com

C'mon... follow us!

Made by, history, ect.

Terms of use:

: view

Privacy policy:

: view

Made by

: http://www.pixelfighters.eu 2010