On Thu, 6 May 2010 11:32:35 +0100, Ian R wrote:

Hi

I'm using Excel 2003.

I'm trying to calculate the total hours (C1) by subtracting end time
(B1) from start time (A1)

I have formatted the cells for time.

I'm currently using B1-A1 which works OK until the end time goes past
midnight.

e.g start 19:50 end 00:20 should = 4:30 except i just get an endless
series of #######

Thanks for your time.

Ian


For up to 24 hrs:

=B1-A1+(B1<=A1)

Format result as h:mm

For more than 24 hours, you will have to include the date also, and format the
result as [h]:mm

--ron