Subtract times?
 

I'm so rusty at this! Could someone remind me how I get the difference
between two columns of Times please? I'm using familiar hours and minutes.

Col A Col B Col C
12:04 12:34 00:30 <--- How do I get this '00:30'?
16:35 18:34 01:59 etc

What cell format do I apply after typing in the data as say HH:MM? And
what function do I use for the result in Column C please?

--
Terry, East Grinstead, UK

Subtract times?
 

Hi Terry,

Am Tue, 31 Jan 2012 10:49:01 +0000 schrieb Terry Pinnell:

Col A Col B Col C
12:04 12:34 00:30 <--- How do I get this '00:30'?
16:35 18:34 01:59 etc

if start and end always in same day, then in C2:
B2-A2 and format hh:mm
If sometimes the end is on next day, then in C2:
=MOD(B2-A2,1) and format hh:mm


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Subtract times?
 

Thanks Claus, understood.

--
Terry, East Grinstead, UK


Claus Busch wrote:

Hi Terry,

Am Tue, 31 Jan 2012 10:49:01 +0000 schrieb Terry Pinnell:

Col A Col B Col C
12:04 12:34 00:30 <--- How do I get this '00:30'?
16:35 18:34 01:59 etc

if start and end always in same day, then in C2:
B2-A2 and format hh:mm
If sometimes the end is on next day, then in C2:
=MOD(B2-A2,1) and format hh:mm


Regards
Claus Busch