Subtracting Times with dates

[Tstewart14]

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

 

[Teethless mama]

=B1-A1

Custom format: [h]:mm

 

[מיכ×ל (מיקי) ×בידן]

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