Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format for duration
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
format for duration
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. -- David Biddulph 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
format for duration
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditonal Format with a date format | Excel Discussion (Misc queries) | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
why does currency format change to number format? | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) |