Subtracting Times with dates
 

I have 4 colums on for start date one for start time one for end date and one
for end time

I need to find a formula that will give me just the difference in the two
times they may be two to 3 days different in the dates. example 3/1/2010
14:30 3/3/2010 22:30 need it to give me the answer of 56:00

Subtracting Times with dates
 

=B1-A1

Custom format: [h]:mm


"Tstewart14" wrote:

I have 4 colums on for start date one for start time one for end date and one
for end time

I need to find a formula that will give me just the difference in the two
times they may be two to 3 days different in the dates. example 3/1/2010
14:30 3/3/2010 22:30 need it to give me the answer of 56:00

Subtracting Times with dates
 

Assuming your 4 values are in cells A1:D1
In E1 type: =D1-B1+C1-A1
and custom format E1 as: [h]:mm
Micky


"Tstewart14" wrote:

I have 4 colums on for start date one for start time one for end date and one
for end time

I need to find a formula that will give me just the difference in the two
times they may be two to 3 days different in the dates. example 3/1/2010
14:30 3/3/2010 22:30 need it to give me the answer of 56:00