Date Subtraction/Time between Occurences

[Losse]

I would like to make something that gives me the number of hours between two days at different times. For example if the two dates were 5/6 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 of the month like the time between 8/30 at 9:00AM and 9/2 at 4:00PM. Any 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)
--
steveB

Remove "AYN" from email to respond
"Losse" <Losse.1s6e6x_1121371612.5947@excelforum-nospam.com> wrote in
message news:Losse.1s6e6x_1121371612.5947@excelforum-nospam.com...
>
> I would like to make something that gives me the number of hours between
> two days at different times. For example if the two dates were 5/6
> 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 of
> the month like the time between 8/30 at 9:00AM and 9/2 at 4:00PM. Any
> ideas of how I could do this?
>
>
> --
> Losse
> ------------------------------------------------------------------------
> Losse's Profile:
> http://www.excelforum.com/member.php...o&userid=24813
> View this thread: http://www.excelforum.com/showthread...hreadid=387298
>

[Losse]

How would I define the dates?

[Losse]

I tried this by just putting the dates as "6-1" for example into the cells and doing it from there. This didn't work. How do I do it 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.

--
steveB

Remove "AYN" from email to respond
"Losse" <Losse.1s7uyn_1121439995.0667@excelforum-nospam.com> wrote in
message news:Losse.1s7uyn_1121439995.0667@excelforum-nospam.com...
>
> I tried this by just putting the dates as "6-1" for example into the
> cells and doing it from there. This didn't work. How do I do it
> correctly?
>
>
> --
> Losse
> ------------------------------------------------------------------------
> Losse's Profile:
> http://www.excelforum.com/member.php...o&userid=24813
> View this thread: http://www.excelforum.com/showthread...hreadid=387298
>

[Losse]

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