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?

calculating the time between one date and another
 

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 (FormatCells...NumberCustom)

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


"Samwar" wrote in message
...
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?