Annoying Time Sheet bug

[w0210613]

Hi,
Problem:
entering in times that involve passing 12 midnight causes an error

ex: 11:30 pm 1:45 am results = 0

I at first tried exceeding the 24 hour barrier
Ex: 1 am = 25:00
This worked but it will confuse the heck out of our managers(not tha
their not bright)

now i want to put an if, then statment along the lines of
IF(B12>A12, insert here formula that can calculate the time afte
midnight)

will this work, if so how would i do it and is There a better way?
Brent :confused

 

[Peo Sjoblom]

2 ways

=B1-A1+(A1>B1)

or

=MOD(B1-A1,1)

where A1 is start and B1 end

 

[w0210613]

I appreciate it, Thank You
: