Thread: Time calculations over 24hrs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ian R[_3_] Ian R[_3_] is offline
external usenet poster
  
Posts: 3
Default Time calculations over 24hrs
In article ,
says...
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


Thanks to you all for taking the time to reply.

Its working perfectly now - just what I needed!

Much appreciated.

Ian I^)

Reply With QuoteReply With Quote