TIMEVALUE

Converts a time in the form of text to a serial number.


Time String Formula Excel TimeStamp Formatted TimeStamp
3:15=TIMEVALUE(A1)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=TIMEVALUE(A2)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=TIMEVALUE(A3)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 AM=TIMEVALUE(A4)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
3:15 PM=TIMEVALUE(A5)0.63541666666667
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:00
5PM=TIMEVALUE(A6)0.70833333333333
Warning: Trying to access array offset on value of type null in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Calculation.php on line 3269
17:00:00
9:15AM=TIMEVALUE(A7)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
13:15AM=TIMEVALUE(A8)#VALUE!
Warning: Trying to access array offset on value of type null in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Calculation.php on line 3269
#VALUE!