calculate elapsed time between dates and times

i have a spreadsheet where i want to calculate elapsed time in hours and
minutes between two dates. dates and times are in separate cells

eg

A2: 01/01/2006 B2:09:30 C2:03/01/2006 D2:11:00

The elapsed time should be 49 hours 30 minutes

is there a formula to calculate elapsed time to give an hour and minute value?

any help would be gratefully received

jenna

=(C2+D2)-(A2+B2)

Format>Cells>Number>Custom, [h]:mm

--
Kind regards,

Niek Otten

"Jenna" <[email protected]> wrote in message
news:[email protected]...
>i have a spreadsheet where i want to calculate elapsed time in hours and
> minutes between two dates. dates and times are in separate cells
>
> eg
>
> A2: 01/01/2006 B2:09:30 C2:03/01/2006 D2:11:00
>
> The elapsed time should be 49 hours 30 minutes
>
> is there a formula to calculate elapsed time to give an hour and minute
> value?
>
> any help would be gratefully received
>
> jenna

--
Gary''s Student
=(A2+B2)-(C2+D2)
and the trick is to format the cell as [h]:mm

"Jenna" wrote:

> i have a spreadsheet where i want to calculate elapsed time in hours and
> minutes between two dates. dates and times are in separate cells
>
> eg
>
> A2: 01/01/2006 B2:09:30 C2:03/01/2006 D2:11:00
>
> The elapsed time should be 49 hours 30 minutes
>
> is there a formula to calculate elapsed time to give an hour and minute value?
>
> any help would be gratefully received
>
> jenna