Accumulating elapsed times.
 

How do I set up a column to record elapsed times (exercise diary entry)? Is
it possible to simply enter hours:minutes:seconds on each row entry or do I
have to set up separate columns with which to calculate everything in the
background somewhere to have it appear in the proper column?

Also, formatting?

Accumulating elapsed times.
 

Have a try! Just type in entries like 1:30:10, 2:40:20, etc. and apply
Autosum! You'll see the correct result: 4:10:30

Regards,
Stefi


€žJohn€� ezt Ã*rta:

How do I set up a column to record elapsed times (exercise diary entry)? Is
it possible to simply enter hours:minutes:seconds on each row entry or do I
have to set up separate columns with which to calculate everything in the
background somewhere to have it appear in the proper column?

Also, formatting?

Accumulating elapsed times.
 

Also format as [h]:mm:ss if the total time is likely to exceed 24 hours.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Stefi" wrote in message
...
Have a try! Just type in entries like 1:30:10, 2:40:20, etc. and apply
Autosum! You'll see the correct result: 4:10:30

Regards,
Stefi


"John" ezt írta:

How do I set up a column to record elapsed times (exercise diary entry)?
Is
it possible to simply enter hours:minutes:seconds on each row entry or
do I
have to set up separate columns with which to calculate everything in
the
background somewhere to have it appear in the proper column?

Also, formatting?

Accumulating elapsed times.
 

It works. Thanks to both of you.

"Bob Phillips" wrote:

Also format as [h]:mm:ss if the total time is likely to exceed 24 hours.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Stefi" wrote in message
...
Have a try! Just type in entries like 1:30:10, 2:40:20, etc. and apply
Autosum! You'll see the correct result: 4:10:30

Regards,
Stefi


"John" ezt Ã*rta:

How do I set up a column to record elapsed times (exercise diary entry)?
Is
it possible to simply enter hours:minutes:seconds on each row entry or
do I
have to set up separate columns with which to calculate everything in
the
background somewhere to have it appear in the proper column?

Also, formatting?