|  

» 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.
Screenshot // Displaying the Serial Number Behind the Time
Displaying the Serial Number Behind the Time

Rate This Tip
12 34 5
Rating: 2.77     Views: 40648
Converting integers to time
mmooney@bctf.ca  Posted on: 31-12-1969
What I'd like to do is convert integers (seconds) to time. Perhaps if there was a way to convert integers to serial numbers, then Excel would be able to format the numbers as time. Is there a way to convert integers to serial numbers?
Reply: Converting integers to time - mmooney@bctf.ca from Vancouver, BC, Canada wrote on April 14, 2003 7:16 PM EST
Alan  Posted on: 31-12-1969
Hi MMooney,

If you have a cell, A1 that contains a number representing seconds (say, 12345), then the following will convert to days (Excel's native unit of time):

A2 =((A1/60)/60)/24 {=0.1428819444...}

In other words, approximately 14% of a day.

To display that answer in, say, hours:mins:seconds, you could apply the custom format:

[h]:mm:ss

which will now display as 3:25:45 or 3 hours, 25 mins, and 45 seconds.

Hope that helps,

Alan.
Name
Comment Title
Comments