close
My best guess at what you want:
=B1-A1 (B1lt;A1)
Biff
quot;peterquot; gt; wrote in message
...
gt;
one way:
A1: 20:00
B1: 03:45
C1: =MOD(B1-A1,1)
Format C1 as time.
In article gt;,
quot;peterquot; gt; wrote:
全站熱搜