Excel Minutes seconds using Excel Custom format

Joined
Feb 12, 2008
Messages
1
Reaction score
0
I need to report in minutes and seconds only. The minutes can be up to 5 digits. I have tried to add a custom format: [h]mmmm:ss, [m]:ss,[mmmm]:ss. What I get when I enter the value is a date or some other value than what I entered. Example 2220:00 and 545:00. Thank you for your help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top