Cell Time Format Problem

S

SiH23

I would be really grateful if someone could offer some help.

I have formatted a cell to accept the time format HH:MM, but when I type in
a value say 3 it converts to 00:00 instead of 03:00. Why is this?

Any help or assistance would be greatly appreciated.

Many thanks,

Simon.
 
K

Kevin B

Excel is treating the number 3 as the third day in its serial date calendar,
which is January 3, 1900.

To indicate that the 3 is an hourly entry enter it using 3:0, or if it's 3
minutes enter it as 0:03
 

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

Adding Time Values in HH:MM Format 3
Date Time formatting problem 7
format time problem 5
number formatting 3
separating date and time 5
Time Conversion issue 5
Entering times in 24 hour format 12
Subtract 12 hours from date/time 6

Top