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)

"Dastard" wrote in
message ...

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


--
Dastard
------------------------------------------------------------------------
Dastard's Profile:
http://www.excelforum.com/member.php...o&userid=34406
View this thread: http://www.excelforum.com/showthread...hreadid=548867