Microsoft Office Forums - View Single Post - Format cells to minutes and seconds

Thread: Format cells to minutes and seconds

View Single Post

Old

09-23-2019, 10:37 PM

ArviLaanemets ArviLaanemets is offline

ArviLaanemets is offline

ArviLaanemets uses Windows 8

Windows 8

ArviLaanemets uses Office 2016

Office 2016

Expert

Join Date: May 2017

Posts: 873

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

ArviLaanemets has much to be proud of

Default

FormatCells>Custom: Into Type field enter the format.

You can also use formats like "[h]:mm:ss" or "[s]", but not "[d]" or "[d] hh:mm:ss".

The feature is available at least from year 2000, when I started to use MS Office instead of Quattro Pro and Visual FoxPro. But I'm not sure about web-based Office! I have MS Office installed in my computer.

Reply With Quote