T
Tipps
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
- 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