how to calculate duration in minutes and seconds

Question

Level 1

13 points

how to calculate duration in minutes and seconds

Hi,

I'm new to using functions in spreadsheets and trying to construct one to keep track of daily exercise routine stats. So far, I've unable to successfully set up cells to compute elapsed time, from start to finish and return the duration. This is as far as I've gotten. I know I'm doing more than one thing wrong but don't know how to climb out of the hole I dug for myself. Any help would be greatly appreciated. Thanks in advance!

All the best,

David

User uploaded file

Cell formula contents:

August 18, 2013 6:15:00 AM =DURATION(,,,,,) =(H2-G2)+DUR2SECONDS(duration)

Wed, Jul 24, 2013

Speed Walk

1

3/4 mi.

1

6:15:00 AM

6:27:00 AM

0w

-2d 23h 48m

MacBook Pro (17-inch Late 2011), OS X Mountain Lion (10.8.3), Final Cut Studio 3, TimeCapsule 1G

Posted on Aug 18, 2013 6:28 AM

Reply

Answer 1

davidas3 Author

Level 1

13 points

Aug 18, 2013 6:43 AM in response to davidas3

Unfortunately, some of the data I included did not transfer and/or were truncated. Sorry for confusion. I can send it separately.

In lieu of the examples, I'm trying to compute the duration of a Start entry and an End entry in Minutes and Seconds.

Reply

Answer 2

Barry

Level 9

60,041 points

Aug 18, 2013 10:36 AM in response to davidas3

Hi David,

Here's an example, using your start and finish times above:

Columns B and C are formatted as: Date and Time, Date: none, Time: 7:08:09 PM

Column D is formatted as shown in the image.

Formula in D2: =C-B

If you haven't yet done so, I strongly recommend downloading and reading at least the first four chapters of the Numbers '09 User Guide, avaliable through the Help menu in Numbers '09.

Regards,

Barry

Reply

Answer 3

davidas3 Author

Level 1

13 points

Aug 18, 2013 12:09 PM in response to Barry

Barry,

Gotcha, thanks for the elucidation and example and quick turnaround! Makes perfect sense. I'm going to follow your advice and read the manual. I'm from the Mac generation (128k) which used to take perverse pride in not having to read Mac manuals. Bad habits persist way into dysfunction.

All the best,

David

Reply