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? |
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? |
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? |
All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com