Excel 2003 - Formatting as minutes to be counted

W

windsong

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?
 
B

Bob Phillips

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

--

HTH

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

windsong

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

Bob Phillips

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)
 
Top