Forum Discussion
Entering time duration in Minutes and seconds
hey all, Ive done this before but I cant seem to remeber or even find the custom format to do it again. I am attempting to imput time duration into my spreedsheet. To be specific I am attempting ...
falconpunch8762 A custom format like #":"#0 will display 130 to 1:30, but the underlying value will still be 130. So, it does not create a real duration from the number you enter. Format it as "Time" and you will get 00:00:00 on the 9th of May, 1900, being midnight on the 130th day in the Excel calendar.