TIME

Returns the serial number of a particular time.


Deprecated: Optional parameter $pCoordinate declared before required parameter $pValue is implicitly treated as a required parameter in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php on line 1477

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Date Value Formula Excel TimeStamp Formatted TimeStamp
Hour Minute Second
315=TIME(A1,B1,C1)0.13541666666667
Warning: Trying to access array offset on value of type null in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
03:15:00
1315=TIME(A2,B2,C2)0.55208333333333
Warning: Trying to access array offset on value of type null in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
13:15:00
151515=TIME(A3,B3,C3)0.63559027777778
Warning: Trying to access array offset on value of type null in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
15:15:15
31530=TIME(A4,B4,C4)0.13576388888889
Warning: Trying to access array offset on value of type null in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
03:15:30
151515=TIME(A5,B5,C5)0.63559027777778
Warning: Trying to access array offset on value of type null in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
15:15:15
5=TIME(A6,B6,C6)0.20833333333333
Warning: Trying to access array offset on value of type null in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
05:00:00
9150=TIME(A7,B7,C7)0.38541666666667
Warning: Trying to access array offset on value of type null in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
09:15:00
915-1=TIME(A8,B8,C8)0.38540509259259
Warning: Trying to access array offset on value of type null in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
09:14:59
13-14-15=TIME(A9,B9,C9)0.53177083333333
Warning: Trying to access array offset on value of type null in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
12:45:45
00-1=TIME(A10,B10,C10)#NUM!
Warning: Trying to access array offset on value of type null in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3349
#NUM!