how to add minutes to give hours using excel e.g. 30m +30m = 1hr
When I use excel to get a sum of cells. e.g add 30 + 30 +30 minutes will
give me 90 instead of 1 hour 30 minutes. How do I set the cells to give me the correct sum total? |
how to add minutes to give hours using excel e.g. 30m +30m = 1hr
=SUM(A1:A3)/24/60
and format as time -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "alphonia" wrote in message ... When I use excel to get a sum of cells. e.g add 30 + 30 +30 minutes will give me 90 instead of 1 hour 30 minutes. How do I set the cells to give me the correct sum total? |
how to add minutes to give hours using excel e.g. 30m +30m = 1hr
If you enter the times as hh:mm:ss, for example, in this case, as 00:30:00,
then, when you add them up, Excel will automatically show the sum as 01:30:00. If the total will exceed 24 hours, format the cell as [hh]:mm:ss Alternatively, you can divide 90 by 24*60 (1440) and format as [hh]:mm:ss That is, for example: =SUM(A2:C2)/(24*60) Regards Trevor "alphonia" wrote in message ... When I use excel to get a sum of cells. e.g add 30 + 30 +30 minutes will give me 90 instead of 1 hour 30 minutes. How do I set the cells to give me the correct sum total? |
All times are GMT +1. The time now is 02:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com