On Tue, 15 Mar 2005 13:55:05 -0800, Jay wrote:

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!

You need to understand how Excel stores and displays time entries.

If you enter 10:52:39 Excel stores this as a fraction of a day. Actually
0.45322916666667

If it is formatted as any kind of time, in the FORMULA BAR it will show as
10:52:39 AM. I don't believe you can change how it is displayed in the formula
bar, if the cell is formatted as time.

You can change how it is displayed in the CELL, however.
Format/Cells/Number/Time and choose 37:30:55 from the drop down list and it
will display, in the cell as 10:52:39. Or you can use a custom format:
Format/Cells/Number/Custom Type:

[h] "hours" mm" minutes" ss" seconds"

will display, in the cell, as 10 hours 52 minutes 39 seconds


However, the number that is stored there is still 0.45322916666667


If you want to add these numbers, in time format, merely add them

=E4+G4+H4

Just be sure, however you format the result, that the hour portion is in
brackets (e.g. [h]:mm:ss) or else the hours will "roll over" at 24 hours.

The sum of those durations is 25:09:27


--ron