formatting cells for time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks for the response that I received from Stefi, and I apologise for being
a bit "thick", but after I formatted/custom and entered mm:ss.00 into the
type box and clicked on OK, what is the correct way to enter the data so the
it will register that it is a time ie do I use forward slashes (/), or dots
(.) or colons (:), or semi colon (;)
Thanks for your help and my apologies again
Terrie
 
Enter as the format:

03:54.76 with the dot

in the formula bar the above will appear as 00:03:35 (hh:mm:ss) with the
seconds rounded.
 

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

time format 5
Enter Time in cells 3
Custom time format help 1
Formating time 2
Excel Cell Format for Time 1
Number Formating Cells (Time) 6
Excel 2003 - Time Formats 5
Format of a cell 1

Back
Top