Excel 2003 - Formatting as minutes to be counted
 

I need to format some cells in MINUTES that can be counted. Entries will be
something like

+25 min
_15 min

And then there will be a cell that tallies the two for the day and then a
cell that tallies for the week. I see no preset formatting that I can use
for this. How would I do this?

Excel 2003 - Formatting as minutes to be counted
 

Just format it,Format,Cells,Custom, as +0"min";-0"min"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"windsong" wrote in message
...
I need to format some cells in MINUTES that can be counted. Entries will
be
something like

+25 min
_15 min

And then there will be a cell that tallies the two for the day and then a
cell that tallies for the week. I see no preset formatting that I can use
for this. How would I do this?

Excel 2003 - Formatting as minutes to be counted
 

Will that ensure that the minutes turn into hours and minutes when the total
reaches 60+ minutes, though?

"Bob Phillips" wrote:

Just format it,Format,Cells,Custom, as +0"min";-0"min"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"windsong" wrote in message
...
I need to format some cells in MINUTES that can be counted. Entries will
be
something like

+25 min
_15 min

And then there will be a cell that tallies the two for the day and then a
cell that tallies for the week. I see no preset formatting that I can use
for this. How would I do this?

Excel 2003 - Formatting as minutes to be counted
 

No, because I have assumed that you are inputting decimal numbers, like 62,
but 1 hour in Excel is a decimal of 0.0416666666666667, and format cannot
step it up by a multiple of 24.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"windsong" wrote in message
...
Will that ensure that the minutes turn into hours and minutes when the
total
reaches 60+ minutes, though?

"Bob Phillips" wrote:

Just format it,Format,Cells,Custom, as +0"min";-0"min"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"windsong" wrote in message
...
I need to format some cells in MINUTES that can be counted. Entries
will
be
something like

+25 min
_15 min

And then there will be a cell that tallies the two for the day and
then a
cell that tallies for the week. I see no preset formatting that I can
use
for this. How would I do this?