Hi,
if you want to add 15 minutes in cell B1 enter

=+A1+TIME(0,15,0)

copy the formula across

"Eric" wrote:

Does anyone have any suggestions on how to display minute format for a cell?
15 minutes is inserted in cell A1, which equals to 12:15 AM
the value in cell A1 adds 15 minutes for cell B1, which equals to 12:30 AM
the value in cell B1 adds 15 minutes for cell C1, which equals to 12:45 AM

Does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric