Using times

C

craigwojo

Thank you for the time formula.

As for the first question: What I'm trying to say is that in th
formula bar it reads the time as AM or PM. I just want to input
time, if I put in 26:00:00 it screws things up in the other cells tha
use this cell as a part of a formula. Excel always looks as if it is
day as I would like to use it as a time basis. Sometimes I need to pu
in a time of 31:55:33 (for an example) but it won't allow me to do thi
with the cell format as TIME. Don't really know what to format it as.

Thank you,
Crai
 

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