Time and Date

[Dastard]

well i have data like this in four cells

date1 time1 date2 time2

this data is in different cells . is it possible that i can have some
formula which could actually count the difference between two times ..
in hours/minutes/seconds .. considering the date aswell since time1 is
on date1 and time2 is on date2 .. so all i need is the duration
inbetween time1 and time2

Regards

 

[Guest]

Hi Dastard

If your data is in A1 to D1 the below will give you whole days

=INT(((A1+B1)-(C1+D1)))

and the below will give the hours (remenber to format this cell for time)

=MOD(((A1+B1)-(C1+D1)),1)

 

[Bob Phillips]

Use =C1-A1-B1+D1 and format the cell as [h]:mm:ss

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)