Thread: Is there a way I can find the time difference between two dates a.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
  
Posts: 860
Default Is there a way I can find the time difference between two dates a.
Hi OutbackPower,

Dates in Excel are stored as numbers - the fractional part of the number is
the time. So if you need the number of hours between two dates (let's say
the dates are in A1 and A2), you could do this:

=(A2-A1)*24

Make sure you format this cell as numeric instead of date/time.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


OutbackPower wrote:
I have two dates and times during those dates. I would like to find
the difference between those two times using an equation. I.E. From
friday 12:00 pm - saturday 12:00 pm its 24 hours.

I have alot of data that I would like to quickly calculate.

Reply With QuoteReply With Quote