Calculating Time
 

I am working on a time management log that captures the time they
start and the time they stop in the spreadsheet. In another column I
use the =TEXT(F2-E2, "h:mm:ss") function to calculate the elapsed
time. How do I calculate the column of elapsed times?

Calculating Time
 

Hi
in this other column don't use this formula as it creates a string
value. Use the formula
=F2-E2
and format this cell with the format hh:mm:ss

Now to add these data use a formula like
=SUM(G2:G10)
and format this cell with the custom format
[hh]:mm

note the '[' brackets. They prevent the rollover after 24 hours


--
Regards
Frank Kabel
Frankfurt, Germany


Tamara wrote:
I am working on a time management log that captures the time they
start and the time they stop in the spreadsheet. In another column I
use the =TEXT(F2-E2, "h:mm:ss") function to calculate the elapsed
time. How do I calculate the column of elapsed times?

Calculating Time
 

Thanks so much, Frank!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!