Microsoft Office Tutorials and References
In Depth Information
Using Functions for Non-English Character Sets
Text Times Entered as
Text Times Entered as M:SS
M:SS Instead of
Instead of H:MM:SS
H:MM:SS
In Figure 11.67 , column B contains a series of time trial results. When
you total the column in cell B12, you realize that all the times were
entered as text.
Figure 11.67.
Figure 11.67. You can use the
You can use the LEFT
text functions to provide the
arguments for the TIME function.
LEFT and
and RIGHT
RIGHT text functions to provide the
arguments for the TIME function.
The formulas in column C use =TIMEVALUE(B2). However, a time such as 2
minutes 50 seconds is converted in the function to 2 hours 50 minutes. In this
case, TIMEVALUE does not work.
There are two alternative strategies:
One solution is to use the TIME function. In column D, the text times
are converted to real times by using the TIME function. In each case,
the hours should be zero. The minutes are =LEFT(B2,1). The seconds
are =RIGHT(B2,2). The formula in cell D2 is
Search JabSto ::




Custom Search