<div>
<div class="content wysiwyg-content">
Given a time in MS format, what is the Excel worksheet formula to give timestamp formatted HHMMSS<br />
<br />
Example: &nbsp;supose Now() is one second before midnight, the formula would give &nbsp;235959 &nbsp;<br />
<br />
Thanks, --Andres
</div>
</div>


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

Excel worksheet formula to give timestamp formatted HHMMSS

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

Exchange

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.