Ask Your Question

calc how to add time increments? [closed]

asked 2017-08-11 15:56:52 +0200

SusanCragin gravatar image

updated 2017-08-11 15:57:24 +0200

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.


8:00 AM


or something like that.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-12 23:29:36.676065

2 Answers

Sort by » oldest newest most voted

answered 2017-08-11 16:11:31 +0200

JohnSUN gravatar image

updated 2017-08-11 16:20:57 +0200

Just add to start time 1 day / (24 hours * 60 minutes) * 15 minutes = 1/96. Formula will be like as


Add Time Interval

Of course you can use the function TIME(0;15;0). But a formula =C2+TIME(0;15;0) seems to me unreasonably cumbersome

edit flag offensive delete link more


+TIMEVALUE("00:15") is also a slightly cumbersome but clearly understandable option.

Lupp gravatar imageLupp ( 2017-08-11 16:47:14 +0200 )edit

Yes, variants ="00:15"+C2 or =C2+"00:15" will work too

JohnSUN gravatar imageJohnSUN ( 2017-08-11 17:20:21 +0200 )edit

Yes. And your variants relying on conversion as well as mine will not work under 'Italian (Italy)' locale. Spreadsheet development made a mess of (next to) everything. We have to rely on the fraction you originally suggested.
It's a pity that not even the standard function TIMEVALUE ensures a correct treatment for a time in internationally standardised formet.

Lupp gravatar imageLupp ( 2017-08-11 18:17:30 +0200 )edit

answered 2017-08-16 13:18:09 +0200

SusanCragin gravatar image

This works! Thank you very much.

edit flag offensive delete link more


I find it really creative to thank with an answer. ;) gravatar ( 2019-09-25 22:04:03 +0200 )edit

Question Tools

1 follower


Asked: 2017-08-11 15:56:52 +0200

Seen: 15,359 times

Last updated: Aug 16 '17