Convert Number to time

preview_player
Показать описание
Convert Number to time

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

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

Holy crap that error sound made me jump lol.

Theportraitdude
Автор

I was exactly searched for. Thanks a lot

FoysalAhmed-wijm
Автор

It only works if you have 4 numbers what if you have 3 numbers

AhmedSM
Автор

This video was very helpful to me. Thank You so much.

anilkushwaha
Автор

THERE NEEDS TO BE AN EASIER WAY TO CONVERT

NVa-yibu
Автор

CAN YOU TELL HOW TO CONVERT THE NUMBERS IN DEGREES ???

bhutanisam
Автор

8.27
12.44
I used the same formula for above both data. one returned with 08:27 & 1:44 as the number chars should be the one.
can you help me to get exact results when changes number chars

tahike
Автор

Hello Amey
The simplest solution I know is:
=--TEXT(A1;"00\:00")

XLarium