Time difference

[Guest]

Hi,

Is is possible to find out the difference between two dates in Hours.

eg 4/4/2007 0.00AM and 5/4/2007 0.00AM

Difference is 24 hrs

Please sort this out...thanks in advance for the help.

 

[Dave Peterson]

Subtract them and multiply by 24 and format as general
or
Subtract them and format as [hh]:mm

=(a1-b1)*24
(formatted as general)

=a1-b1
(formatted as time)

 

[Guest]

Maybe

=(B1-A1)*24

Where A1 is the earlier date/time. Format as general

Mike

 

[Pete_UK]

If the dates are in Excel date format then just subtract one from the
other and format the resulting cell using a custom setting of
[hh]:mm:ss if you want the result to also be in date format. If you
want the result to be in hours, then do something like:

=(end_time - start_time)*24

and format the cell as number.

Hope this helps.

Pete

 

[Guest]

OK...
how to do if both the dates happen to be same

eg eg 4/4/2007 0.00AM and 4/4/2007 1.00AM ...

i want the time difference as I hour

 

[Dave Peterson]

What did the suggested formula return?

OK...
how to do if both the dates happen to be same

eg eg 4/4/2007 0.00AM and 4/4/2007 1.00AM ...

i want the time difference as I hour

 

[David Biddulph]

To get Excel to recognise those as dates, try changing 0.00 to 0:00 (with a
colon), and leave a space between that and the AM. After that, follow the
suggestions of the other respondents. You'll also need to be sure that your
Windows Regional Settings recognise your format as DMY, not MDY.

 

[Guest]

Exactly the same way

01/01/2007 00:00 01/01/2007 01:00
=(B1-A1)*24

Would give an answer of 1.

Mike

 

[Guest]

Sorry Boss...it was my mistake...got it ........

thanks for you time and help

 

[Guest]

Thanks Boss....got it

Subtract them and multiply by 24 and format as general
or
Subtract them and format as [hh]:mm

=(a1-b1)*24
(formatted as general)

=a1-b1
(formatted as time)

Hi,

Is is possible to find out the difference between two dates in Hours.

eg 4/4/2007 0.00AM and 5/4/2007 0.00AM

Difference is 24 hrs

Please sort this out...thanks in advance for the help.

 

[Jerome]

if the start date is in E2 and the end date in F2 then use the following
formula. It displays the difference in hours and mins.

=INT((F2-E2)*24)&" hrs: "&INT((((F2-E2)*24)-(INT((F2-E2)*24)))*60)&" mins"

best regards,

Jerome

 

[Rick Rothstein \(MVP - VB\)]

If you use these values

E2: 12/19/2007 4:30:00 PM

F2: 12/21/2007 4:17:00 AM

your formula returns 35 hrs: 46 mins which is 1 minute off. This much
smaller formula seems to return the correct values...

=TEXT(F2-E2,"[h] \h\r\s: m \m\i\n\s")

Rick

 

[Jerome]

Hi Rick,

Thanks for the valuable feedback its much appreciated ... I love this forum
for all the valuable expertise it gives ... have a gr8 day

Jerome

If you use these values

E2: 12/19/2007 4:30:00 PM

F2: 12/21/2007 4:17:00 AM

your formula returns 35 hrs: 46 mins which is 1 minute off. This much
smaller formula seems to return the correct values...

=TEXT(F2-E2,"[h] \h\r\s: m \m\i\n\s")

Rick

if the start date is in E2 and the end date in F2 then use the following
formula. It displays the difference in hours and mins.

=INT((F2-E2)*24)&" hrs: "&INT((((F2-E2)*24)-(INT((F2-E2)*24)))*60)&" mins"

best regards,

Jerome

 

[Rick Rothstein \(MVP - VB\)]

You are welcome. By the way, I notice that your posting is a response to
someone else posting, but it shows up in my newsreader as starting a new
message thread. I looked for the original message you responded to, but I
couldn't find it. Apparently, that message was (very?) old and is not in my
downloaded database of messages for this newsgroup. So, I'm guessing the
original poster is not going to see our messages.

Rick

Hi Rick,

Thanks for the valuable feedback its much appreciated ... I love this
forum
for all the valuable expertise it gives ... have a gr8 day

Jerome

If you use these values

E2: 12/19/2007 4:30:00 PM

F2: 12/21/2007 4:17:00 AM

your formula returns 35 hrs: 46 mins which is 1 minute off. This much
smaller formula seems to return the correct values...

=TEXT(F2-E2,"[h] \h\r\s: m \m\i\n\s")

Rick

if the start date is in E2 and the end date in F2 then use the
following
formula. It displays the difference in hours and mins.

=INT((F2-E2)*24)&" hrs: "&INT((((F2-E2)*24)-(INT((F2-E2)*24)))*60)&"
mins"

best regards,

Jerome

:

Hi,

Is is possible to find out the difference between two dates in Hours.

eg 4/4/2007 0.00AM and 5/4/2007 0.00AM

Difference is 24 hrs

Please sort this out...thanks in advance for the help.