calculating the time between one date and another

Hi there. I have a worksheet with four cells in it:

Start Date
Start Time
End Date
End Time.

I need to calculate in hours the diffrence between the two. I am using Excel
2000 and unfortunately the cells have to remain seperate. Can anyone please
help?

Samwar

With the entries in A1:A4 (Later date/time in A3 and A4) then in A5 enter

=(A3+A4)-(A1+A2)

and format the result as (Format>Cells...>Number>Custom)

[hh]:mm

the square brackets stop hours over 24 from incrementing to days

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"Samwar" <[email protected]> wrote in message
news:[email protected]...
> Hi there. I have a worksheet with four cells in it:
>
> Start Date
> Start Time
> End Date
> End Time.
>
> I need to calculate in hours the diffrence between the two. I am using
> Excel
> 2000 and unfortunately the cells have to remain seperate. Can anyone
> please
> help?