Just enter it as 00:35 and Excel will automatically format it.

For the totals cell, format as [h]:m in case it exceeds 24 hours.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


wrote in message
oups.com...
x-no-archive:
for example, if I want to enter 35 min in a cell, how would I format it
to resemble minutes? Or 1 hour? Also, how would I format a cell to
TOTAL a bunch of cells with minutes?