calculating the time between one date and another

[Guest]

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?

 

[Nick Hodge]

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
(e-mail address removed)