View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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?