Thread: adding time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.