Convert seconds into Days hh:mm:ss format in Excel

preview_player
Показать описание
The video offers a short tutorial on how to convert time given in seconds into Days hh:mm:ss format in Excel.
Рекомендации по теме
Комментарии
Автор

Thanks for this! Just what i needed. Im playing with time in excel, i figured the way to convert to the smallest increment of time, seconds, for duration. From there i can divide into percentages, like how long it took to reach 5, 10, 25% ect, project the time remaining in sec, add the start time and now with this i can return back to the original Format and add to the start time to return the projected finish time. yeah, kinda nerd'n out. Thanks again!

migocctx
Автор

Hi Jignesh! I want to convert 1d 6h into hh:mm:ss format. How do I do that? How do I get it converted into 30:00:00?

MrYojrr