add minutes on hour

  • Thread starter Thread starter denizcan
  • Start date Start date
D

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.
 
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
 
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
 
Back
Top