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!