Jul 13 2020 02:17 AM
Jul 13 2020 03:24 AM
The number it is converting it to isn't really irrelevant. Excel uses a decimal number to represent the number of days relative to a fixed date.
The decimal part is the fraction of 1 that is represented by the current time of day. So, if it is 5AM, then the decimal part will be equivalent to 5/24.
If you want to convert your times to a numeric value, then consider what you hope to do with the number after you have it. If you want to do any kind of mathematical operation, then I recommend leaving it in the datevalue format.
If this is just a display issue, then @Sergei Baklan 's answer is ideal and you should accept his answer
as the best solution.
If you still want to convert to a number, then use the format suggested above in the TEXT function, then convert to a number using NUMBERVALUE:
Jul 13 2020 03:27 AM
It is a number, we only changed the format. One hour in Excel is equal 1/24, thus 04:59 is equal to 0.207638888888889. That is the value of it, you may apply General format and check.
Applied format is only makes for this number more human friendly representation, 04:59 or 459, whaever.