Excel 2003 Date time formatting problems and timetable

  • Thread starter Thread starter Peter B North
  • Start date Start date
P

Peter B North

Hi I'm trying to produce a timetable and each time I try and format
the cells so that I have day, date and time the time just reverts to
12:00am. I reformat the cell, but it takes no notice. I've tried
separating the two things out in columns and the time still comes up
as 12:00 am and when I look at the formula at the top there's a date
there too.
I've tried clear formatting and still no joy.

Anybody any ideas. I've done it before with Excel 2000, but in 2003
it's a real problem.

Timetable
Trying to create a simple school timetable anybody any good, simple
ideas.

Thanks

PBN
 
Peter,

You've left out some stuff. What's in the cells? Do Edit - Clear - Formats
(you can undo it in a moment). What do you see? It should be a whole
number (left of the decimal point) for the date part, and a fraction (right
of the decimal point) for the time part. Read up on date/time stuff at
www.cpearson.com.
 
When you read Chip's datetime.htm page or my own with the same
name, keep in mind that time is measured as a fraction of a day.
Guess that was stated. How about double checking by using
another column =B2 format as d hh:mm:ss
I suspect you may have entered as mm:ss when Excel would
interpret that as hh:mm in which case you would have to
multiply by 60. Though you didn't just say just some showed 12:00 AM.

Also if totaling that you would format time as [h]:mm to keep hours
from rolling into days and not shown.
 
Back
Top