Excel VBA Tips
Search This Blog
Sunday, 19 August 2012
CHANGE TIME FORMAT FROM "HH:MM Hrs" TO "HH:MM:SS"
Formula in B2:
=TEXT(LEFT(A2,2)/24+MID(A2,4,2)/1440,"hh:mm:ss") and drag it down.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment