Format time as quantity, not clock

E

Ed

I'm trying to input time as a quantity - 15 hours and 30 minutes. Excel
keeps changing it to a clock time - 3:30 PM. What is the correct cell
format to use to keep time as quantity?

Ed
 
J

JE McGimpsey

In Format/Cells/Number/Time there is, in most if not all versions, a
format that displays time with no AM/PM. In my version it's

37:30:55

but you can also use the equivalent custom format:

Format/Cells/Number/Custom [h]:mm:ss
 

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

Top