| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custum Cell Format - display 0 (zero) when cell is empty | New Users to Excel | |||
| How do I format a cell in excel to display 0.5 hrs as 00:30 | Excel Discussion (Misc queries) | |||
| Question on Format in Hour & Minute | Excel Worksheet Functions | |||
| Cell format, want 100 to display as 1.00 | Excel Discussion (Misc queries) | |||
| Format a cell to display as all caps | Excel Discussion (Misc queries) | |||
Linear Mode
