software

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)

Formatgt;Cellsgt;Numbergt;Custom, [h]:mm

--
Kind regards,

Niek Otten

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

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

quot;Jennaquot; wrote:

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