Share via

Can't find Custom category in Format Cell menu

Anonymous
2016-09-08T21:29:47+00:00

I am creating a spreadsheet in Excel Mobile App for Android and I can't find the Custom category under the Format Cells menu.  All the other category options are there, but Custom is not.  I want to include start time and end time columns and have a final column calculate and display the elapsed time as h:mm.  The h:mm selection is under the Custom category in the PC program, but not in the Mobile App.  Currently it just displays the result as a time, AM or PM instead of just elapsed time in h:mm.  Is the Custom category somewhere else or is there a way to manually input it?

Microsoft 365 and Office | Install, redeem, activate | For home | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-09-09T21:10:28+00:00

    Hi Bobbie,

    You may follow the below steps and check if you can find the h:mm format.

    1. In the Excel spreadsheet, click on the symbol A in the file ribbon.
    2. Now scroll and select Format Number.
    3. Now you should see an "Time" option, click on the right arrow.
    4. Check if h:mm format is available.

    Please be informed that custom category option is not available in Excel mobile. If this is feature that you would like see in Excel mobile app. You may please provide feedback in the Excel user voice section.

    https://excel.uservoice.com/forums/304939-excel-for-android

    Thank you.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments