Tip Printed from ExcelTip.com

---

Displaying the Serial Number Behind the Time


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.