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-Pro


"Well Missy" wrote:

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.