Time Conversion (2) - KING OF EXCEL

Tuesday, January 7, 2020

Time Conversion (2)

Time Conversion (2)

Image
Answer:
=TEXT(Your 4-digit number,”00\:00″)+0 ‘Format the result as TIME
About a quarter ago, I wrote a post about how to convert a 4-digit number into TIME with a formula using ROUND, MOD functions together with some mathematical operations.
Just last week, I wrote another post about how to convert an 8-digit number into Excel-recognizable Date, which uses TEXT function basically.
I like the latter trick more as I considered that more intuitive and easier to use.  The trick is also applicable to converting a 4-digit number into TIME, with just a little modification:
=TEXT(Your 4-digit number,”00\:00″)+0 ‘Format the result as TIME
i.e. it turns something like 0123 to 01:23 nicely in Excel.
To learn more how it works, check my post on how to convert an 8-digit number into Excel-recognizable Date as they follow the same logic.
See!? We may achieve the same goal in so many different ways in Excel.
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

No comments:

Post a Comment