adding rows of hours and minutes to get a total
Hi there. I have a timesheet with a column (Col. B) containing minutes
- the range is B16 to B26, with more rows being added as I add more time. I have converted the minutes into hours and minutes using this formula: =INT(B16/60)&" hours "&MOD(B26,60)& " minutes" =INT(B17/60)&" hours "&MOD(B26,60)& " minutes" etc. which gives me the hours and minutes in Col. C I now want a grand total of the hours and minutes from C16 to c26. Any help greatly appreciated. Col. B Col. C Time Total time 90 1 hours 30 minutes 35 0 hours 35 minutes 45 0 hours 45 minutes 20 0 hours 20 minutes 105 1 hours 45 minutes 10 0 hours 10 minutes 25 0 hours 25 minutes 5 0 hours 5 minutes 120 2 hours 0 minutes 30 0 hours 30 minutes 60 1 hours 0 minutes Thanks. Tipps |
adding rows of hours and minutes to get a total
Ah, got it thanks.
Tipps Tipps said this on Nov 04, 05 1:59 PM: Hi there. I have a timesheet with a column (Col. B) containing minutes - the range is B16 to B26, with more rows being added as I add more time. I have converted the minutes into hours and minutes using this formula: =INT(B16/60)&" hours "&MOD(B26,60)& " minutes" =INT(B17/60)&" hours "&MOD(B26,60)& " minutes" etc. which gives me the hours and minutes in Col. C I now want a grand total of the hours and minutes from C16 to c26. Any help greatly appreciated. Col. B Col. C Time Total time 90 1 hours 30 minutes 35 0 hours 35 minutes 45 0 hours 45 minutes 20 0 hours 20 minutes 105 1 hours 45 minutes 10 0 hours 10 minutes 25 0 hours 25 minutes 5 0 hours 5 minutes 120 2 hours 0 minutes 30 0 hours 30 minutes 60 1 hours 0 minutes Thanks. Tipps |
All times are GMT +1. The time now is 01:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com