In article <OQXhlH2sIHA.5872@[EMAIL PROTECTED]
>, bubba@[EMAIL PROTECTED]
wrote:
> Thanks for any help you can give me on this.<br>
First, it's much more polite to post in plain text...
Second, XL stores times as fractional days, so one minute corresponds to
1/(24*60) = 1/1440.
One way (format all cells as times, if necessary):
C1: =A1
D1: =A1 + B1/1440
C2: =D1
D2: =C2 + B2/1440
Copy C2:D2 down as far as required.
Note: If your times span midnight, XL will, if the cells are displayed
as times, "roll over" the display - i.e., 1.25 displays as 6:00 AM. If
you want to roll over the *value* (i.e., 11:00 PM + 240 minutes = 0.125
rather than 1.125):
C1: =A1
D1: =MOD(A1 + B1/1440, 1)
C2: =D1
D2: =MOD(C2 + B2/1440, 1)
|
