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

[ADG]

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)
--
Tony Green


"Dastard" wrote:

>
> 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
>
>

[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)

"Dastard" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>