feeding the TIMEVALUE function a time

[havoc]

Hi
I want to enter a time value into a Time formatted field (as in, 8:00
AM)
and then feed that value into the TIMEVALUE function to get the decimal
time equivalent.
The TIMEVALUE function only takes quoted text as an argument (as in,
"8:00AM").
How do I convert from my Time format field to a quoted text argument
for the function?
It tried the "T" function. No luck.
Thank you

 

[Bernard Rey]

havoc a écrit :

I want to enter a time value into a Time formatted field (as in, 8:00
AM) and then feed that value into the TIMEVALUE function to get the
decimal time equivalent.

Wouldn't it be easier then to simply write it:

=A1*24

Provided A1 is the cell in which you have entered the time value, and that
this new cell is *not* formatted as time (or date), it would display "8.5"
if cell A1 displays "8:30AM".

The TIMEVALUE function only takes quoted text as an argument (as in,
"8:00AM").
How do I convert from my Time format field to a quoted text argument
for the function? It tried the "T" function. No luck.

The "TEXT" function could do it, but you'll need to make sure the format is
right. Something like:

=TIMEVALUE(TEXT(A1,"hh:mm"))*24

Would give the same result as above (under the same conditions)...

 

[havoc]

Thank you for the suggestions!