Figuring amount of time elapsed

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
-------------------------------------------

carrera said:
Hi
Using military time, what would the formula be to figure the amount of
Click to expand...
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
Click to expand...
question, and it never comes up.
 
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)

carrera said:
Hi
Using military time, what would the formula be to figure the amount of
Click to expand...
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
Click to expand...
question, and it never comes up.
 
Back
Top