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

start time in A1 and end time in B1

=MOD(B1-A1,1)

or

=B1-A1+(A1B1)

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"bmg" wrote in message
...
i want to figure out the hours between two different times even if they go
into the next day ?

On Mon, 20 Feb 2006 20:42:11 -0800, bmg 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

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" wrote in message
...
i want to figure out the hours between two different times even if they go
into the next day ?