Date Value | Formula | Excel TimeStamp | Formatted TimeStamp | ||
---|---|---|---|---|---|
Hour | Minute | Second | |||
3 | 15 | =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 | |
13 | 15 | =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 | |
15 | 15 | 15 | =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 |
3 | 15 | 30 | =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 |
15 | 15 | 15 | =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 | ||
9 | 15 | 0 | =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 |
9 | 15 | -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 |
0 | 0 | -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! |