Solved

Excel worksheet formula to give timestamp formatted HHMMSS

Posted on 2011-03-11
1
572 Views
Last Modified: 2012-05-11
Given a time in MS format, what is the Excel worksheet formula to give timestamp formatted HHMMSS

Example:  supose Now() is one second before midnight, the formula would give  235959  

Thanks, --Andres
0
Comment
Question by:AndresHernando
1 Comment
 
LVL 9

Accepted Solution

by:
Ramanhp earned 500 total points
ID: 35114576
=TEXT(NOW(),"HHMMSS")

you may replace now() function with the reference to another cell containing datetime
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
how to add IIS SMTP to handle application/Scanner relays into office 365.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question