adding time

G

Greg

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

Gary''s Student

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
 
Top