Is there a way I can find the time difference between two dates a.
 

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.

Is there a way I can find the time difference between two dates a.
 

=EndDateAndTime - StartDateAndTime

format the cell with a custom number format

hh:mm

or

=(EndDateAndTime - StartDateAndTime)*24

to get decimal hours.

--
Regards,
Tom Ogilvy

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

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.