Time calculations ?

by bubba@[EMAIL PROTECTED] May 11, 2008 at 08:24 AM

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
Can't quit figure this one out.<br>
<br>
I need to add minutes to a specified time and have it calculate new
times.<br>
In other words, I need to enter data once in Column A and for every
event in Column B, and have Excel calculate Columns C and D event
times.<br>
<br>
Example:<br>
<br>
&nbsp;&nbsp; Col. A&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; Col. B&nbsp;&nbsp;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;
Col. C&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; Col. D<br>
<font color="#000099">(entered once)&nbsp;</font>&nbsp; &nbsp;&nbsp;&nbsp;
<font color="#000099">&nbsp;
(entered for each Event)</font>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <font
color="#ff0000">&nbsp;&nbsp;&nbsp;
(calculated)&nbsp;</font> &nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; <font color="#ff0000">(calculated)</font><br>
<u>Beginning Time</u> &nbsp;&nbsp;&nbsp; <u>EVENT Elapsed Minutes
</u>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <u>Event
Start time</u> &nbsp;&nbsp;&nbsp;&nbsp;<u> Event finish Time</u><br>
<font color="#000099">12:01 AM &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;
&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; 60&nbsp;</font>&nbsp; &nbsp;&nbsp;
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; <font
color="#ff0000"><i>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; 12:01 AM&nbsp;&nbsp; &nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; 1:01 AM</i></font><br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;
&nbsp;&nbsp; &nbsp;&nbsp;<font color="#000099"> &nbsp;&nbsp;&nbsp;
90&nbsp;</font>&nbsp;
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; <font color="#ff0000"><i>&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 1:01 AM&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 2:31 AM</i></font><br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;
&nbsp;&nbsp; &nbsp;&nbsp; <font color="#000099">&nbsp;&nbsp;&nbsp;
30&nbsp;</font>&nbsp;
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;
&nbsp;&nbsp;<i>&nbsp; <font color="#ff0000">&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 2:31 AM&nbsp;&nbsp; &nbsp;&nbsp;
&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; 3:01 AM</font><br>
<br>
</i>Thanks for any help you can give me on this.<br>
<br>
John<i><br>
</i><br>
<br>
<br>
</body>
</html>

3 Posts in Topic:

Time calculations ?

bubba@[EMAIL PROTECTED]

2008-05-11 08:24:00

Re: Time calculations ?

JE McGimpsey <jemcgimp

2008-05-11 15:57:55

Re: Time calculations ?

bubba@[EMAIL PROTECTED]

2008-05-12 07:43:01

Post A Reply:

About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup
tan12V112 Wed Jul 9 6:04:46 CDT 2008.