Adding Time With Minutes Increment

[netchie]

Hi,

I am having a hard time to add time to specific minutes. So if I put 10:00 on A1 and 15 min on B1, it should give me automatic time as 10:15 on C1, 10:30 on D1, and 10:45 on E1.

A1 B1 C1 D1 E1
10:00 15 min. 10:15 10:30 10:45


Your help is truly appreciated

Thanks,
netchie

 

[T. Valko]

Hi,

I am having a hard time to add time to specific minutes. So if I put 10:00 on A1 and 15 min on B1, it should give me automatic time as 10:15 on C1, 10:30 on D1, and 10:45 on E1.

A1 B1 C1 D1 E1
10:00 15 min. 10:15 10:30 10:45


Your help is truly appreciated

Thanks,
netchie

Try this...

Book1
	A	B	C	D	E
1	10:00 AM	15	10:15 AM	10:30 AM	10:45 AM
Sheet1

Formula entered in C1:

=$A1+TIME(0,$B1*COLUMNS($C1:C1),0)

Format as Time

Copy across as needed

 

[netchie]

Thanks T. Valko

I have one more question if you don't mind. So what if my A2:A5 is blank as well as B2:5 (you know, like still waiting to input the time), how can I keep the formula to C2:C5 without getting time declared already in C2:C5. right now, since A2:A5 and B2:B5 are blank, C2:C5 has automatic 12:00AM on them? How can i jeep the formula without showing the 12:00AM? (i hope I make sense)

 

[T. Valko]

Thanks T. Valko

I have one more question if you don't mind. So what if my A2:A5 is blank as well as B2:5 (you know, like still waiting to input the time), how can I keep the formula to C2:C5 without getting time declared already in C2:C5. right now, since A2:A5 and B2:B5 are blank, C2:C5 has automatic 12:00AM on them? How can i jeep the formula without showing the 12:00AM? (i hope I make sense)

Try it like this:

=IF(COUNT($A1:$B1)<2,"",$A1+TIME(0,$B1*COLUMNS($C1:C1),0))

The time cells will remain blank until both the start time and the number of minutes is entered.

 

[netchie]

OMG! you rock T. Valko!

Thank you so so much! Wheeew! you made my brain relax now.

Thanks again and have a wonderful day!

netchie

 

[T. Valko]

OMG! you rock T. Valko!

Thank you so so much! Wheeew! you made my brain relax now.

Thanks again and have a wonderful day!

netchie

You're welcome. Thanks for the feedback!

 

[netchie]

Hi T. Valko,

Please don't get mad but there's tiny changes now. Minutes are not in B2:B5 anymore. It will be in different cells for 5 min, 15 min, 30 min, etc.

So let's say:

A1 10:00 D5 - 5 min C1 - result (formula) - 10:05AM
A2 10:45 J5 - 15 min C2 - result (formula) - 11:00AM
A3 - blank P5 - blank C3 - blank 9since there's no data yet in A3 and P5

I don't know the formula

 

[T. Valko]

Hi T. Valko,

Please don't get mad but there's tiny changes now. Minutes are not in B2:B5 anymore. It will be in different cells for 5 min, 15 min, 30 min, etc.

So let's say:

A1 10:00 D5 - 5 min C1 - result (formula) - 10:05AM
A2 10:45 J5 - 15 min C2 - result (formula) - 11:00AM
A3 - blank P5 - blank C3 - blank 9since there's no data yet in A3 and P5

I don't know the formula

I don't understand the relationship of the cells with the minutes and the cells with the start time.

Why does D5 correspond to A1 and J5 correspnd to A2?