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.
No comments:
Post a Comment