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:

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()