Solved

Excel worksheet formula to give timestamp formatted HHMMSS

Posted on 2011-03-11
1
546 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Easy CSR creation in Exchange 2007,2010 and 2013
Local Continuous Replication is a cost effective and quick way of backing up Exchange server data. The following article describes the steps required to configure Local Continuous Replication. Also, the article tells you how to restore from a backup…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now