Entering times into an Excel spreadsheet

  • Thread starter Thread starter DavidLilley
  • Start date Start date
D

DavidLilley

I'm trying to create a column in a spreadsheet for a "time" - 24 hour clock
showing hour and minutes.

I've tried formatting the cell as a time, and also as a "custom" cell -
however, every time I enter the data and press return, the figures all
change. Any ideas??!!
 
Look if you have fixed decimal set under tools>options>calculation

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
You must log in or register to reply here.

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

Daily Time Sheets with Rounding 1
Excel Formula Bar Time Display Format 2
Conditional formatting in Excel 2010 2
Entering 'GTi' but I get 'Gti' ! 2
stopwatch times 7
Excel Convert Datetime Stamp to HH and MM Worked 7
Display time format 1
How do I enter time (12-hour clock) & have it display it? 3

Back
Top