adding time
In A1 we enter:
9:15
In B1 we enter the number 35
In C1 we enter the formula:
=A1+B1/(60*24) we must also format C1 as Time.
In A1 thru C1 we see:
9:15 35 9:50:00 AM
So if the class starts at 9:15 and is 35 minutes long, it will end at 9:50
--
Gary''s Student - gsnu200773
"Greg" wrote:
I need a spreadsheet that will make bell schedules for a school. eg. enter a
start time and the number of minutes per class and have it give end times for
each class.
|