time table calulation formula

  • Thread starter Thread starter Phil
  • Start date Start date
P

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
 
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)
 
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)
 
Back
Top