» Displaying the Serial Number Behind the Time

CATEGORY - Excel Time VERSION - All Microsoft Excel Versions

Using keyboard shortcuts

The time's serial number is between 0 and 1 (noon serial time = 0.50).
To display the serial number behind the time:

1. Press Ctrl+Shift+; to insert the current time into cell A1.
2. Press Ctrl+` to display the serial number of the current time.
Screenshot // Displaying the Serial Number Behind the Time