add minutes on hour
 

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.
--
Deniz

add minutes on hour
 

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
--
If this helps, please remember to click yes.


"denizcan" wrote:

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.
--
Deniz

add minutes on hour
 

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

"denizcan" wrote:

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.
--
Deniz