How to display minute format for a cell?

[Eric]

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

 

[Eduardo]

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

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

copy the formula across

 

[Luke M]

15 minutes = 15/(24*60)
So, you could either write
=A1+15/(24*60)
or
=A1+TIME(0,15,0)

 

[Gary''s Student]

Format A1 thru C1 as Time 1:30PM

In A1 enter:
00:15

In B1 enter:
=A1+TIME(0,15,0)

In C1 enter:
=B1+TIME(0,15,0)

 

[David Biddulph]

If you want to see the time as a number of minutes, format as [m]

 

[David Biddulph]

But don't bother with the unnecessary + sign.

=+A1+TIME(0,15,0) can happily be changed to just =A1+TIME(0,15,0)

[But I thought that the question was about the formatting of the cells, not
about the formulae? Perhaps I misunderstood?]

 

[Eric]

Thank everyone very much for suggestions
in Cell A1 =Time(0,15,0), and the display format is m, but it returns 1
instead of 15, if I want to display 12:15 AM, what should I set for
displaying format?
Thank everyone very much for any suggestions
Eric

If you want to see the time as a number of minutes, format as [m]
--
David Biddulph

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

 

[Luke M]

format cell:
h:mm AM/PM
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Thank everyone very much for suggestions
in Cell A1 =Time(0,15,0), and the display format is m, but it returns 1
instead of 15, if I want to display 12:15 AM, what should I set for
displaying format?
Thank everyone very much for any suggestions
Eric

If you want to see the time as a number of minutes, format as [m]
--
David Biddulph

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

 

[Eduardo]

Hi,
set it to

h:mm AM/PM

Thank everyone very much for suggestions
in Cell A1 =Time(0,15,0), and the display format is m, but it returns 1
instead of 15, if I want to display 12:15 AM, what should I set for
displaying format?
Thank everyone very much for any suggestions
Eric

If you want to see the time as a number of minutes, format as [m]
--
David Biddulph

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

 

[Mike Rogers]

Eric

I may be reading this a little different than others, so if I am not correct
just pitch this.

I think what you are trying to do is add 15 minutes to each cell down a
column. To have 15 minutes read as 00:15 it needs to be entered this way,
not 15. What I would do is enter 00:15 in a cell, say D1, and in A1 I would
enter 12:00 and format as "1:30 PM". I would enter in A2 =A1+$D$4 and drag
down thus incrementing every 15 minutes. The $ make that row and column
absolute keeping it as the reference for all cells the formula is dragged to.

 

[David Biddulph]

I didn't say format as m, I said [m]. The square brackets are significant,
and [m] will give you 15.

If you want 12:15 AM, rather than 15, then format as h:mm AM/PM or hh:mm
AM/PM.
--
David Biddulph

Thank everyone very much for suggestions
in Cell A1 =Time(0,15,0), and the display format is m, but it returns 1
instead of 15, if I want to display 12:15 AM, what should I set for
displaying format?
Thank everyone very much for any suggestions
Eric

If you want to see the time as a number of minutes, format as [m]
--
David Biddulph

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