add minutes on hour

[denizcan]

i want to prepare bell times chart that starts at 9:00am and incresing with
50 min. I want the result to be shown as 9:50,10:40 etc. thanking you in
advance.

 

[Paul C]

Format your cells as Time 9:00 AM.

enter 9:00 in the first cell (A1)

The trick is to know that for this format 50 minutes is not simply +50 but
needs to be expressed as fractionally

For Cell A2 enter the formula =A1+50/(60*24) and copy down

 

[JH]

Try, adding your time to 00:50
eg: enter 10:00 AM in a cell, 00:50 in the next cell, simply add them
together.

JH