How do I keep excel from changing minute and second times into AM.

J

Jake

I am having a problem with Excel
I put times in as minutes and seconds, and attempt to use the format cell
command and have tried every option under time and custom.
The program keeps reading 20:02 (20 minutes and two seconds) as 10:02 PM,
how can I keep this from happening?
 
J

Jake

Thanks, but the problem is this still reads as a time
when i enter values greater than 24 for the first number, it converts it
into military time, and for values less, when i divide by 2 it gives me
incorrect answers because it is still reading it as a time
 
N

Niek Otten

Format>Cells>Number tab, Custom. In the Type box, enter [h]:mm:ss

What are incorrect answers? what's your formula? your input values? your
results?
What's wrong with "reading it as time"? It is time, isn't it? Am I missing
something?
 

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

PowerPivot How to chart with contiguous time axis? 0
Time Values As Numbers 3
How do I set focus (and select text) on a text box on a modeless userform? 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
How do I enter mins and secs in Excel without using caps/colon 2
using time data copied and pasted into excel from external source 4
i want to convert decimals into time format 5
Time calculations 3

Top