» Displaying the Serial Number Behind the Time
CATEGORY - Excel Time
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- Understanding Financial Statements
- The One Page Business Plan: Start With a Vision, Build a Company!
- PowerPoint® 2002 For Dummies®
- Absolute Beginner's Guide to Microsoft Excel 2002
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
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.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
