time table calulation formula

[Phil]

first time posting for help in the new group - looking for
formula for timetable creation. have never done timetable
prior to this. (see below)

Column A
8:54pm

Column B needs to reflect column A 8:54pm plus 8 minutes
and show result of 9:02pm

Column C need to reflect column b plus 8 minutes and show
result of 9:10pm

currently getting # value error
thanks

 

[Arvi Laanemets]

Hi

B2=A2+8/(24*60)
Copy B2 to C2
Copy B2:C2 down

When formulas return error, then probably in column A aren't time values,
but text values instead. Check cell formats, or for preceeding apostrophes.
To convert numeric values (numbers, dates or times) of text format into
right numeric format, reformat the column at first. Then copy a number 1
from any cell, select the range to convert, and then select
PasteSpecial.Multiply (copying a 0, and PasteSpecial.Add will do same too)

 

[Bob Phillips]

B1: =A1+TIME(0,8,0)
C1: =B1+TIME(0,8,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Gord Dibben]

Bob/Phil

=A1+TIME(0,0,8) works for me.

Gord Dibben Excel MVP

 

[Bob Phillips]

??

That's only 8 seconds?

Bob

Bob/Phil

=A1+TIME(0,0,8) works for me.

Gord Dibben Excel MVP

 

[Gord Dibben]

By gorsh, you're right.

Back to the TV for me<g>

Gord