calculating time

[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

 

[Peo Sjoblom]

=C2-B2 (23:55:19 - 23:20:35)

if the times can extend over midnight

=MOD(C2-B2,1)

 

[Bob Phillips]

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)