Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

calc how to add time increments?

I want to make out a time sheet for students, showing how they spend their time in 15-minute increments. But they can start their day wherever they want. I need column on the left that says start time on the top, and then underneath that a formula that adds a 15-minute increment to whatever the time is.
So: 8:00 AM 8:00+00:15

or something like that.

calc how to add time increments?

I want to make out a time sheet for students, showing how they spend their time in 15-minute increments. But they can start their day wherever they want. I need column on the left that says start time on the top, and then underneath that a formula that adds a 15-minute increment to whatever the time is.

So:

8:00 AM AM

8:00+00:15

or something like that. that.