TIME

Returns the serial number of a particular time.


Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

Warning: Trying to access array offset on value of type int in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line 74

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 /var/www/erp/spreadsheet/src/PhpSpreadsheet/Calculation.php on line 3269
03:15:00
1315=TIME(A2,B2,C2)0.55208333333333
Warning: Trying to access array offset on value of type null in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Calculation.php on line 3269
13:15:00
151515=TIME(A3,B3,C3)0.63559027777778
Warning: Trying to access array offset on value of type null in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Calculation.php on line 3269
15:15:15
31530=TIME(A4,B4,C4)0.13576388888889
Warning: Trying to access array offset on value of type null in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Calculation.php on line 3269
03:15:30
151515=TIME(A5,B5,C5)0.63559027777778
Warning: Trying to access array offset on value of type null in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Calculation.php on line 3269
15:15:15
5=TIME(A6,B6,C6)0.20833333333333
Warning: Trying to access array offset on value of type null in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Calculation.php on line 3269
05:00:00
9150=TIME(A7,B7,C7)0.38541666666667
Warning: Trying to access array offset on value of type null in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Calculation.php on line 3269
09:15:00
915-1=TIME(A8,B8,C8)0.38540509259259
Warning: Trying to access array offset on value of type null in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Calculation.php on line 3269
09:14:59
13-14-15=TIME(A9,B9,C9)0.53177083333333
Warning: Trying to access array offset on value of type null in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Calculation.php on line 3269
12:45:45
00-1=TIME(A10,B10,C10)#NUM!
Warning: Trying to access array offset on value of type null in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Calculation.php on line 3269
#NUM!