How to display minute format for a cell?

  • Thread starter Thread starter Eric
  • Start date Start date
E

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
 
Hi,
if you want to add 15 minutes in cell B1 enter

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

copy the formula across
 
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)
 
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?]
 
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 said:
If you want to see the time as a number of minutes, format as [m]
--
David Biddulph

Eric said:
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
Click to expand...
Click to expand...
 
format cell:
h:mm AM/PM
--
Best Regards,

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


Eric said:
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 said:
If you want to see the time as a number of minutes, format as [m]
--
David Biddulph

Eric said:
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
Click to expand...
Click to expand...
Click to expand...
 
Hi,
set it to

h:mm AM/PM

Eric said:
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 said:
If you want to see the time as a number of minutes, format as [m]
--
David Biddulph

Eric said:
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
Click to expand...
Click to expand...
Click to expand...
 
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.
 
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 said:
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 said:
If you want to see the time as a number of minutes, format as [m]
--
David Biddulph

Eric said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top