How To Convert Time to a Number in Excel?

Question

Hello,

Im seeking assistance converting time to a number in excel.

I want to set the time as just a number. As an example. From the screenshot below I want 0:11:16 to just appear as 11

The cell is custom set to h:mm:ss

Any assistance most appreciated

Thank you

Answer 1

Hi respected  JDou#s#t,

Thanks for your valuable feedback, glad to know that my replies helped you.

I appreciate your kind words.

Meanwhile, if you find our suggestions helpful and my explanation and correct direction on this whole scenario, you can also use the feedback tool below our reply to submit your feedback for us (pictured below).

Your feedback really means a lot to the dedicated members of our community.

If there is any issue related with the Office applications in the future, please feel free to post back in this community.

We will be here for help.

Have a good day and stay safe 😊

Best wishes

Waqas Muhammad

Answer 2

Dear respected  JDou#s#t,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description,

1.Using custom formatting:

In the Format Cells dialog, go to the Number tab>Select Custom from the list on the left>In the Type field, enter the following format:

[m]

2.Using Formula:

=VALUE(TEXT(A1, "[m]"))

If there is any misunderstanding, I apologize and please feel free to post back to us with more detailed information for better understanding and guiding you further.

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

I'm sorry and I apologize for that.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad

Answer 3

Thank you very much Waqas

That worked a treat.

Answer 4

Hi respected  JDou#s#t,

I'm writing a follow up this case, and I haven’t received any information from you,Feel free to post back if you need further assistance.

Have a good day and stay safe 😊

Sincerely,

Waqas Muhammad