Forum Discussion
mickbrooks3196
Nov 23, 2021Copper Contributor
Microsoft Office 2019 Excel
When I type in a time as 08.25, it alters it to 0600.
3 Replies
- GregReddickCopper ContributorWhen 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_EekelenPlatinum Contributor
mickbrooks3196 Try 08:25
- mickbrooks3196Copper Contributor
Riny_van_Eekelen Thank you for that.