Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am attempting to find the difference between two dates... | Excel Discussion (Misc queries) | |||
difference between two dates and before a certain time | Excel Discussion (Misc queries) | |||
find the difference between start time and end time when spanning. | Excel Discussion (Misc queries) | |||
how do i put formula to find difference between two dates | New Users to Excel | |||
Time Difference between two dates | Excel Programming |