Text Function to convert Number to Time

preview_player
Показать описание

Thanks for Watching
Feel Free to Subscribe and
Watch more videos on exploring excel

Thankyou.
Рекомендации по теме
Комментарии
Автор

Thank you.
Is there no way to do this without adding additional columns?

irfinity
Автор

And what if we are talking about 0005, 0010, like midnight an 5 minutes? The formulas don't work.

leibnitz
Автор

Hi! Can you help me please? I would like to convert number to date without having to do it manually(e.g 19880930 to 1988/09/30). I have a spreasheet with more than 8000 numbers to convert but i can't seem to find a formula for this. Hope you can help me.
Thank you so much!

neuzaafonso