Custom format code and a BUG?!

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

Guest

H
Set the custom format code [hh]:mm:ss on a cell
Enter 23:65:00. The value is transformed to the time "1900-01-01 00:05:00" and the cell displays 24:05:0
Enter 24:65:00. The value is still 24:65:00 and the cell displays 24:65:00
Is this a bug or what is the reason behind this behaviour
Regard
/Nikla
PS I use Excel 2000 on Win2000
 
Hi Niklas!

The second entry is now text; you can confirm using ISTEXT(A1).

Excel has treated the second entry as an invalid time and decided that
it must be text. If you subsequently enter a valid time it will take
the time format. I suppose that the mystery is why the first entry is
accepted. Without pre-format as [hh]:mm:ss an entry of 24:65:00 would
be treated as text.



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Niklas said:
Hi
Set the custom format code [hh]:mm:ss on a cell.
Enter 23:65:00. The value is transformed to the time "1900-01-01
Click to expand...
00:05:00" and the cell displays 24:05:00
 
Back
Top