formula in excel to track times between two different dates ?

[bmg]

i want to figure out the hours between two different times even if they go
into the next day ?

[Peo Sjoblom]

start time in A1 and end time in B1

=MOD(B1-A1,1)

or

=B1-A1+(A1>B1)

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"bmg" <bmg@discussions.microsoft.com> wrote in message
news:B640AEE2-83A2-413D-9387-71C39090C532@microsoft.com...
>i want to figure out the hours between two different times even if they go
> into the next day ?

[Ron Rosenfeld]

On Mon, 20 Feb 2006 20:42:11 -0800, bmg <bmg@discussions.microsoft.com> wrote:

>i want to figure out the hours between two different times even if they go
>into the next day ?

A1: 2/6/06 7:00
A2: 2/9/06 4:45

=A2-A1

Format/Cells/Number Custom Type: [h]

-->69


--ron

[Biff]

Hi!

If the difference is 24 hours or more, you'll have to include dates.

Examples:

A1 = 6:00 PM
B1 = 11:00 AM (next day)

Formula: format the cell as [h]:mm

=B1-A1+(B1<A1)

Returns 17:00

A1 = 2/20/2006 6:00 PM
B1 = 2/21/2006 7:00 PM

Returns 25:00

Biff

"bmg" <bmg@discussions.microsoft.com> wrote in message
news:B640AEE2-83A2-413D-9387-71C39090C532@microsoft.com...
>i want to figure out the hours between two different times even if they go
> into the next day ?