Microsoft Office 2019 Excel

New Contributor

When I type in a time as 08.25, it alters it to 0600.

3 Replies
best response confirmed by mickbrooks3196 (New Contributor)

@mickbrooks3196 Try 08:25

When you do 08.25, you are actually entering the date January 8, 1900 at 6 a.m. This is 8 and a quarter days past the Excel zero date.

@Riny_van_Eekelen  Thank you for that.