Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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

=C2+1/96

Add Time Interval

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

=C2+1/96

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

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

=C2+1/96

Add Time Interval

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