Adding Hours & Minutes On A Table

**Whispy** · 05-04-2014, 08:44 PM

I use a task table to add up the hours and minutes I spend on specific tasks. It looks like this:

Task Time Table.png

Is there a way to get Excel to convert every 60 minutes to 1 hour in the hours column?

So instead of showing the totals of 6 and 90, it would show totals of 7 and 30.

Thank you for your time!

**martindwilson** · 05-04-2014, 09:05 PM

column b
=TEXT(SUM($B$3:$B$7)/24+SUM($C$2:$C$7)/1440,"[h]")+0 cell formated general
column c
=MOD(SUM(C2:C7),60)

	A	B	C
1
2	a		30
3	b	4	30
4	c		30
5	d		20
6	e		20
7	f	2
8
9		=TEXT(SUM($B$3:$B$7)/24+SUM($C$2:$C$7)/1440,"[h]")+0	=MOD(SUM(C2:C7),60)

	A	B	C
1
2	a		30
3	b	4	30
4	c		30
5	d		20
6	e		20
7	f	2
8
9		8	10

**martindwilson** · 05-04-2014, 09:12 PM

or maybe shorter
b9= =SUM(B2:B7)+(SUM(C2:C7)-MOD(SUM(C2:C7),60))/60
c9= =MOD(SUM(C2:C7),60)

**Whispy** · 05-04-2014, 09:24 PM

Thank you! The first code works perfectly! The second one leaves a decimal on the hours.

Adding Hours & Minutes On A Table

LinkBack

Thread Tools

Rate This Thread

Display

Adding Hours & Minutes On A Table

Re: Adding Hours & Minutes On A Table

Re: Adding Hours & Minutes On A Table

Re: Adding Hours & Minutes On A Table

Thread Information

Users Browsing this Thread

Similar Threads

Adding hours and minutes

Adding Minutes and hours

Adding hours and minutes

Adding Hours:Minutes

Adding hours and minutes

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions