|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 4th, 2005, 06:59 PM
|
|||
|
|||
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 
|
|
#2
November 4th, 2005, 07:03 PM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Convert minutes into hours and minutes | southtxxbox | Worksheet Functions | 6 | March 29th, 2008 09:16 AM |
| Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | StargateFan | General Discussion | 8 | January 7th, 2006 07:35 PM |
| Sum minutes and seconds to total hours | deck4 | General Discussion | 3 | August 29th, 2005 02:34 PM |
| MOD Function or how to convert total minutes to hours and minutes | Brad | Setting Up & Running Reports | 1 | December 22nd, 2004 08:07 AM |
| Adding up hours and minutes | Lynn | Worksheet Functions | 6 | February 5th, 2004 02:31 PM |
Linear Mode
