calculating time

  • Thread starter Thread starter William
  • Start date Start date
W

William

I have an excel spread sheet that has 3 times set in
military format;

Column A Column B Column C
23:15:22 23:20:35 23:55:19

I want to calculate the time difference between column c
and column b. How do I do that? Autosum seems to add, but
I want to subtract.

Thanks

Bill
 
Bill,

It's as simple a
=C1-B1

If the result doesn't look like time (say .02314), just format it as time.

--

HTH

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