<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<pre wrap="">First, thanks for the info!
Second, my formating was intended for clarity's sake only.
Your response ("First, it's much more polite to post in plain text...")
was inappropriate.
"Politeness" had absolutely nothing to do with it...
I suggest that a better response might have been:
"No need to use any but plain text for your questions."
Or,
"Please post all future questions in plain text."
Just because you are smart or well versed in XL, doesn't mean that you
have the right to be impolite, yourself.
***************
</pre>
<br>
<br>
JE McGimpsey wrote:
<blockquote
cite="mid:jemcgimpsey-EA9C5F.15575511052008@[EMAIL PROTECTED]
"
type="cite">
<pre wrap="">In article <a class="moz-txt-link-rfc2396E"
href="mailto:OQXhlH2sIHA.5872@[EMAIL PROTECTED]
"><OQXhlH2sIHA.5872@[EMAIL PROTECTED]
>,
<a class="moz-txt-link-abbreviated"
href="mailto:bubba@[EMAIL PROTECTED]
">bubba@[EMAIL PROTECTED]
>
wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Thanks for any help you can give me on this.<br>
</pre>
</blockquote>
<pre wrap=""><!---->
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)
</pre>
</blockquote>
<br>
</body>
</html>
|
