Time calculations ?

[bubba]

Can't quit figure this one out.

I need to add minutes to a specified time and have it calculate new times.
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.

Example:

   Col. A                       Col. B                                 Col. C                       Col. D
(entered once)         (entered for each Event)            (calculated)               (calculated)
Beginning Time     EVENT Elapsed Minutes        Event Start time      Event finish Time
12:01 AM                          60                                 12:01 AM               1:01 AM
                                         90                                  1:01 AM               2:31 AM
                                         30                                  2:31 AM               3:01 AM

Thanks for any help you can give me on this.

John

 

[JE McGimpsey]

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 C22 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)

 

[bubba]

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. ***************



JE McGimpsey wrote:

Thanks for any help you can give me on this.&lt;br&gt;



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 C22 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)