ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   adding time (https://www.excelbanter.com/excel-discussion-misc-queries/179842-adding-time.html)

Greg

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.

Gary''s Student

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