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