Jay,

The way that I read your question it seem to me that you want to enter a
time ie 10:52:39 AM but have it show in the cell as 10 hours, 52 minutes
and 39 seconds yet still be used in a calculation, I would think that the
answer would be no, a cell cannot hold two different things at the same
time. What I suppose you could do would be to have an event macro which
copied the entered time value to a cell in a hidden column and then build
the text representation of it in the origoinal cell and use the copied time
value in calculations. However, if you then wanted the sheet to alter the
time itself after the calculation then you will be stuck.

It would be a lot simpler to have both forms of the times in adjacent cells.
If say the time is entered in E4 then in F4 have the formula:

=IF(ISNUMBER(E4),HOUR(E4)& " Hours " & MINUTE(E4) & " Minutes " & SECOND(E4)
& " Seconds","")

The font colour in E4 can be set to white, (or the background colour if not
set to 'no fill'), so that the real time in E4 will only show up in the
formula bar when the cell is selected.

HTH

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Jay" wrote in message
...
I have this application in which values of time are plugged (i.e.): 10
hours,
52 minutes and 39 seconds (10:52:39 AM). These values are used in
calculations at some point within the worksheet. As it stands Excel does
not
allow this to happen easily, since whenever the value is entered it takes
on
a time value. I have as examples column E cell E:4=10:52:39 AM, colunm G
cell
G:4=2:10:46 AM, column H cell H:4=12:06:02 AM. These three columns are ALL
supposed to be numeric values of 10 hrs, 52 mins,39 sec and 2 hrs,10
mins,46
sec and 12 hrs, 52 mins, 2 seconds.

Is there a method for getting these values to show up and work as numeric
values within their respective columns? If there is, can you supply a work

around or solution by way of a function or line(s) code that will do this?

Appreciate any assistance on this matter. Thanks!