Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding Time | Excel Worksheet Functions | |||
Adding time | Excel Worksheet Functions | |||
Adding time AM/PM | Excel Discussion (Misc queries) | |||
Time log adding time from separate sheets | New Users to Excel | |||
Adding time to date-time formatted cell | Excel Discussion (Misc queries) |