[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel worksheet formula to give timestamp formatted HHMMSS

Posted on 2011-03-11
1
Medium Priority
?
597 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 2000 total points
ID: 35114576
=TEXT(NOW(),"HHMMSS")

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

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

As much as Microsoft wants to kill off PST file support, just as they tried to do with public folders, there are still times when it is useful or downright necessary to export Exchange mailboxes to PST files. Thankfully, it is still possible to e…
This article will help to fix the below errors for MS Exchange Server 2016 I. Certificate error "name on the security certificate is invalid or does not match the name of the site" II. Out of Office not working III. Make Internal URLs and Externa…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Suggested Courses

865 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