software

I have an equation where I am subtract time based on 24 hours. For example,

1:00 a.m. - 23:00 p.m. = 2

how do I build the equation to obtain an answer of 2 hours? Help.

Since you're crossing over midnight, try something like this:

For
A1: 1:00
B1: 23:00
C1: =MOD( A1-B1,1)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Well Missyquot; wrote:

gt; I have an equation where I am subtract time based on 24 hours. For example,
gt;
gt; 1:00 a.m. - 23:00 p.m. = 2
gt;
gt; how do I build the equation to obtain an answer of 2 hours? Help.

Missy,

Assuming:
23:00 pm means 11:00 PM (23:00 pm is text NOT an Excel time)

A1= 01:00 (or 1:00 AM)
B1= 23:00 (or 23:00 PM)

try:
=((A1-B1) (A1lt;B1)) formatted as time or

=((A1-B1) (A1lt;B1))*24 formatted as General for the number 2 or

=MOD(A1-B1,1) for time or

=MOD(A1-B1,1)*24 for number

--
HTH

Sandy
with @tiscali.co.ukquot;Well Missyquot; gt; wrote in message
news
gt;I have an equation where I am subtract time based on 24 hours. For
gt;example,
gt;
gt; 1:00 a.m. - 23:00 p.m. = 2
gt;
gt; how do I build the equation to obtain an answer of 2 hours? Help.