Thread: Please Help Calculate Time Between 2 different Dates
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dtown Dawg Dtown Dawg is offline
external usenet poster
  
Posts: 22
Default Please Help Calculate Time Between 2 different Dates
Actually I just went in and formated the cell as a number instead of time and
it works just fine.

"Dave O" wrote:

With your sample data in A1:B2, try this formula in C2:
=((A2+B2)-(A1+B1))*24


Reply With QuoteReply With Quote