Question

What will be the output of the following function in Calc?=TIME (20;30;25)

options :

1)20:30:25 AM
2)08:30:25 PM
3) 08:30:25 AM
4) 20:30:25 PM​

Answer 1

Answer:

option

2 and 4 because 20 in opljhi

Answer 2

Answer:

2) 08:30:25 PM

Explanation:

Calc works with elements called spreadsheets. Spreadsheets consists of several individual sheets, where each sheet contains cells arranged in rows and columns. A particular cell is identified by its row number and column letter. It is intuitive and easy to learn. TIME function returns the time, given hours, minutes and seconds.

Syntax:

TIME(hours; minutes; seconds)

returns the time, expressed in the form of date-time serial number. Hours, minutes and seconds are integers. If hours, minutes and seconds are not within range for a valid time then the time will 'roll over'.

Example - TIME(9; 31; 75) - It returns 9:32:15 AM, the time rolls over, as there are only 60 seconds in a minute.

#SPJ3