How to convert a number to time units

preview_player
Показать описание
If you want to convert a number to time values, you need to do bunch of multiplication and division between days, hours, minutes and seconds. We will show you a simpler approach by using Excel's TEXT function. Here is how to convert a number to hours, minutes, and seconds.
Рекомендации по теме
Комментарии
Автор

Actually trying to do the same but other way around. How??? Any suggestions to covert for example: 1m 30s to 1.5 or 4m 30s to 4.5 ???? Please

tonytaf
Автор

Hello, Its not working for me, Giving an error ( There's a problem with this formula)

CinemaInsight