TIMEVALUE function example

[nebb]

When using many of the worksheet functions, cell addresses designat
that the contents of those cells are be used. Example: Sum(a1,a2): th
result being the total of the contents of the two cells.
In other worksheet functions, such as the TIMEVALUE function, a cel
address apparently cannot be used or can it?
Example:
TIMEVALUE("2:24 AM") equals 0.1

If cell A1 contained "2:24 AM" , TIMEVALUE(A1) does not give th
same result.

Is there some way of using the contents of cell A1 in the TIMEVALU
function to get the proper result

 

[Myrna Larson]

The formula is OK as written. Try applying a time format to the cell with the
formula. Let us know what you see <g>.

 

[Max]

If cell A1 contained "2:24 AM" , TIMEVALUE(A1) does not give the

same result.

Is there some way of using the contents of cell A1 in the TIMEVALUE
function to get the proper result?

Just a thought .. maybe you're trying to say, in C1,
add a specified number of hours in B1 to the time in A1 ?
(B1 assumed to contain numbers representing hours)

If so, there's no need to use TIMEVALUE

Just put in C1: =A1+B1/24
and format C1 as: Time - "1:30 PM"

You would need to divide the number in B1 (hours) by 24

A number say: "1" input in a cell
is read as = 1 day for date-time calcs

If B1 contains the number 5, C1 will return 7:24 AM
If B1 contains the number 12, C1 will return 2:24 PM

 

[Myrna Larson]

His problem, I think, is that his formula cell is not formatted as time. If it
were, he would see 2:24 AM

 

[Max]

well, I read this part ..

If cell A1 contained "2:24 AM" , TIMEVALUE(A1) does not give the
same result.

as implying OP had tried in say, B1: =TIMEVALUE(A1)
which returns #VALUE!

The rest of the response are mere guesses inferred from the OP's post
as to what he's really after ..

 

[Arvi Laanemets]

Hi

Enter time into A1 preceeded with apostrophe
'2:24 AM
or format cell A1 as text before, and then enter the time string as
2:24 AM

Now your formula must work. You had time, not time string in A1 before.