Date Subtraction/Time between Occurences

[Losse]

I would like to make something that gives me the number of hours betwee
two days at different times. For example if the two dates were 5/
6:00AM and 5/8 8:00AM, the number of hours between the two would be 50
I would also like this to be able to work at for days near the end o
the month like the time between 8/30 at 9:00AM and 9/2 at 4:00PM. An
ideas of how I could do this

 

[STEVE BELL]

if A1 = 1st date (prior to most recent)
A2 = 2nd date (most recent)

in A3 = (A2-A1)*24

providing that A1 and A2 are formated in any date formate.

(doesn't matter if dates cross months or years. just need to be different)

This works because Excel sees dates as a number
Each increment of 1 = a day or 24 hours.
decimals = hours and minutes (.5 >> 24 * .5 = 12 hours)

 

[Losse]

How would I define the dates

 

[Losse]

I tried this by just putting the dates as "6-1" for example into th
cells and doing it from there. This didn't work. How do I do i
correctly

 

[STEVE BELL]

Any acceptable date format should work, including date/time...

6/1
6-1
worked for me in Excel 2000.

Just make sure that you don't enter them as Text.

 

[Losse]

Edit: Thank you. I was able to get it to work.