Excel Magic Trick 1262

DESCRIPTION

Convert Times Values to HHMM Text or Text HHMM Values to Time Values
Learn how to use the TEXT function and custom Number Formatting to:
(00:12) Convert Times Values to HHMM Text with TEXT function and Custom Number Formatting “hhmm”
(01:29) Convert Text HHMM Values to Time Values with TEXT function and Custom Number Formatting “00\:00”. Learn how to use the back slash \ character to insert a single character into a Number Formatting.

WORKBOOKS




Be the first to comment

Leave a Reply