View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sloth
 
Posts: n/a
Default Cell Formatting...

Don't use the TEXT function. Simply subtract the two times and use a custom
number format.

How to Create a custom number format:
1. Select the cells you want to format.
2. On the Format menu, click Cells, and then click the Number tab.
3. In the Category list, click Custom.
4. In the Type box, insert this...
[h]:mm:ss
5. Click Okay

To SUM the elapsed times use the SUM function and then use the same custom
number format.

"Steven Sinclair" wrote:

Okay...I have figured out part of it.

I have a column of start times (E), a column of stop times (F), and a column
of elapsed times (G). For the formula in the cells for column (G), I have
placed the following:

=TEXT(F3-E3,"hh:mm:ss")

This properly gives me the elapsed time between columns (E) and (F).

Now, at the bottom of column (G), I'd like to be able to have a total of all
the elapsed times, but can't figure out that formula.

Any ideas?

Thanx.