Figuring amount of time elapsed

[Guest]

H
Using military time, what would the formula be to figure the amount of hours/minutes that have elapse
for example column A is 17:56, column B is 20:03. How could I get column C to equal 2:07

Don't know what I'm doing wrong, this is the 3rd time I've posted this question, and it never comes up.

 

[Earl Kiosterud]

Carrera,

In C2:

=B2-A2

If it doesn't format itself properly, format it manually (Format - Cells -
Time). Copy down with Fill Handle.

If you don't see your post, you may need to set up an account with
msnews.microsoft.com. If you're instead using your ISP's news server, you
may miss posts, or they may take a long time. In Outlook, it's Tools -
Accounts - Add - News.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Hi
Using military time, what would the formula be to figure the amount of

hours/minutes that have elapsed

for example column A is 17:56, column B is 20:03. How could I get column C to equal 2:07 ?

Don't know what I'm doing wrong, this is the 3rd time I've posted this

question, and it never comes up.

 

[Bob Phillips]

This is the first time I can see it, the last post from you was one on
worksheet names on 4th.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi
Using military time, what would the formula be to figure the amount of

hours/minutes that have elapsed

for example column A is 17:56, column B is 20:03. How could I get column C to equal 2:07 ?

Don't know what I'm doing wrong, this is the 3rd time I've posted this

question, and it never comes up.