Excel worksheet formula to give timestamp formatted HHMMSS

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
AndresHernandoAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
RamanhpConnect With a Mentor Commented:
=TEXT(NOW(),"HHMMSS")

you may replace now() function with the reference to another cell containing datetime
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.