Nov 30 2021 12:04 AM
Nov 30 2021 12:19 AM
@Bernadine945 219:38:50 is recognised as the 219th hour (plus minites and seconds) starting from January 1, 1900, the first day in Excels's date system. Excel figured out that you want to display it as hours:minutes:seconds and has applied a custom format to it [h]:mm:ss. However, the underlying value is still number representing date and time. That's why you see the 1900 date with time in the formula bar. If you do not need to calculate with the hours value entered, format the cell/column where you intend to enter these values as text. Then, they will remain text (as entered), i.e. not change to a date/time format. Alternatively, enter an apostrophe or a space before the hhh:mm:ss when you enter it.