How to display minute format for a cell?
 

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

How to display minute format for a cell?
 

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

How to display minute format for a cell?
 

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

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


"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

How to display minute format for a cell?
 

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)
--
Gary''s Student - gsnu200859


"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

How to display minute format for a cell?
 

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

"Eric" wrote in message
...
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

How to display minute format for a cell?
 

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?]
--
David Biddulph


"Eduardo" wrote in message
...
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

How to display minute format for a cell?
 

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

"David Biddulph" wrote:

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

"Eric" wrote in message
...
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

How to display minute format for a cell?
 

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

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


"Eric" wrote:

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

"David Biddulph" wrote:

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

"Eric" wrote in message
...
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

How to display minute format for a cell?
 

Hi,
set it to

h:mm AM/PM

"Eric" wrote:

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

"David Biddulph" wrote:

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

"Eric" wrote in message
...
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

How to display minute format for a cell?
 

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.

"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

How to display minute format for a cell?
 

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

"Eric" wrote in message
...
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

"David Biddulph" wrote:

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

"Eric" wrote in message
...
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