format for duration

F

fornewsgroups

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

David Biddulph

0:35 for 35 minutes
1:00 for 1 hour
(You can custom format as h:mm, rather than hh:mm, if you want).
If you want the total to be shown as number of minutes, rather than in Excel
time format, then use =(A1+A2)*24*60 and format as General (or number),
rather than as time.
 
B

Bob Phillips

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