![]() |
adding time
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. |
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. |
All times are GMT +1. The time now is 09:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com