I am using excel 2007. Try this in your own excel sheet. in cell A1 I write 10:30, and the cell is automatically well-known beside a time format.
Then I come contained by cell D to write this function:
=TIMEVALUE(A1)
This function should return the serial number of the time contained by cell A1, but instead it writes #VALUE! error in cell D
Please if you know the answer I will donate a Best Answer right away.
Answers: Excel 2007 have a tooltip that appears when you are entering a formula. Notice that the parameter inside the parenthesis have to be time_text -- which is not a number. Numbers are not text, and vice versa. The TIMEVALUE function converts text into a number.
You own two choices:
1.) Alter your formula to simply verbs the number that already exists within cell A1.
= A1
2.) If you're compelled to use the TIMEVALUE function, convert the good point surrounded by cell A1 to deed.
= TIMEVALUE ( TEXT ( A1, "hh:mm" ) )
the TIMEVALUE function desires a string, not a time format.
so if A1 have a course book string of 10:30 (type '10:30 and press Enter) afterwards the formula works.