software

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 (A1gt;B1)

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;bmgquot; gt; wrote in message
...
gt;i want to figure out the hours between two different times even if they go
gt; into the next day ?On Mon, 20 Feb 2006 20:42:11 -0800, bmg gt; wrote:

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

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

=A2-A1

Format/Cells/Number Custom Type: [h]

--gt;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 (B1lt;A1)

Returns 17:00

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

Returns 25:00

Biff

quot;bmgquot; gt; wrote in message
...
gt;i want to figure out the hours between two different times even if they go
gt; into the next day ?