Apr 11 2023 01:49 AM
In Excel 365, if a time value is displayed in scientific notation (e.g., 1.23E+01), you can change the format of the cell to display the value as a time.
Format numbers as dates or times
When you type a date or time in a cell, it appears in a default date and time format. This default format is based on the regional date and time settings that are specified in Control Panel, and changes when you adjust those settings in Control Panel. You can display numbers in several other date and time formats, most of which are not affected by Control Panel settings.
In this article
Please, see the insert file.
Hope this helps! :)