calculate amount of time difference

A

Andre

Hello folks. I'm trying to figure out how to get excel to calculate time
differences between two AMOUNTS of time, not TIME OF DAY. Specifically:

1:34:24 should be interpreted as 1 hour, 34 minutes, 24 seconds, not 1:34:24
AM

1:25:24 likewise

Difference should be 9:00, as in 9 minutes, 0 seconds.

Thanks for any assistance.

--
 
N

Norman Harker

Hi Andre!

Use:

Latest-Earliest

As in:

B1-A1
Format [mm]:ss

I've surrounded the mm with [ and ] so that it will record differences
of +60 as minutes not hours.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top