Forum Discussion
Time to Number Format
Hello, I'm needing a time format such as 18:34 to be in a number only format (so, 18:34 = 1834, 04:59 = 459, 01:10 = 110 etc) Does anyone know the formulae to do this? Thank you.
Okay, how would I change it so it can be a number? If I change it to text, it converts it to a decimal that is irrelevant.
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.
Thank youSergeiBaklan
I wasn't aware that the decimal represented that so I learnt something new today.
Thank you for your help and the format concept did help me achieve what I needed.
dillanpatel , you are welcome