SECOND Function (Functions in Excel)
Number | Second | |
14/May/10 15:02:50 | 50 | =SECOND(C4) |
12:00:00 PM | 0 | =SECOND(C5) |
0.50 | 0 | =SECOND(C6) |
0.51 | 24 | =SECOND(C7) |
1.51 | 24 | =SECOND(C8) |
What Does It Do? |
The function will show the second of the minute based upon a time or a number. |
Only the fraction part of the number is used as it is this which relates to time of day. |
Syntax |
=SECOND(Number) |
Formatting |
The result will be shown as a normal number between 0 and 59. |
Example |
The following table was used by a telephone compnay to calculate the cost of a call. |
The telephone company only deals in seconds which are a multiple of 5. |
The seconds in a call are rounded up to the nearest multiple of 5 before the bill is calculated. |
The Duration of the call is entered. |
The =MINUTES() function calculates the total number of minutes. |
The =SECOND() function calculates the total number of seconds. |
The =CEILING() function rounds the seconds up to the nearest muliple of 5. |
The Cost of the call is then calculated. |
Cost Per Second : | £0.01 | ||
Billed Duration | |||
Duration | Minutes | Seconds | Cost |
0:01:08 | 1 | 10 | £0.70 |
0:02:03 | 2 | 5 | £1.25 |
0:01:47 | 1 | 50 | £1.10 |
=CEILING(SECOND(C36),5) | |||
0 comments:
Post a Comment