=MOD(A1-B1,1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Clueless" wrote in message
...
I need to subtract 32 minutes from every cell in a long column. The format
is
24 hour clock, so I tried the formula =A2-B1. This works, until it gets
down
to midnight.
Example: 00:30 - 00:32 should equal 23:58. But all i get is error
messages
saying there are negative numbers etc...
Which formula can I use that would recognize the 24hour clock and the
transitions from 23:59 to 00:00 midnight?