SECOND ()
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.
Best view in desktop mode.
|
A
|
B
|
C
|
D
|
|
|
1
|
Different Format Time
|
Second
|
||
|
2
|
19/Feb/20 20:37:16
|
16
|
=SECOND(A2)
|
|
|
3
|
12:00:00 PM
|
0
|
=SECOND(A3)
|
|
|
4
|
0.50
|
0
|
=SECOND(A4)
|
|
|
5
|
0.51
|
24
|
=SECOND(A5)
|
|
|
6
|
1.51
|
24
|
=SECOND(A6)
|
|
|
7
|
||||
Syntax
=SECOND(serial_number)
Formatting
The result will
be shown as a normal number between 0 and 59.
Example
The following
table was used by a telephone company 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.
|
A
|
B
|
C
|
D
|
E
|
F
|
|
|
1
|
Cost Per Second :
|
$ 0.01
|
||||
|
2
|
||||||
|
3
|
Billed Duration
|
|||||
|
4
|
Duration
|
Minutes
|
Seconds
|
Cost
|
||
|
5
|
0:01:08
|
1
|
10
|
$ 0.70
|
=($D$1*B5*60)+($D$1*C5)
|
|
|
6
|
0:02:03
|
2
|
5
|
$ 1.25
|
=($D$1*B6*60)+($D$1*C6)
|
|
|
7
|
0:01:47
|
1
|
50
|
$ 1.10
|
=($D$1*B7*60)+($D$1*C7)
|
|
|
8
|
=CEILING(SECOND(A5),5)
|
|||||
|
9
|
||||||
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 multiple of 5.
The Cost of the
call is then calculated.
No comments:
Post a Comment