SUMIF formula to get total hrs.

asyamonique

Well-known Member
Joined
Jan 29, 2008
Messages
1,220
Office Version
  1. 2013
Platform
  1. Windows
TotalTime
122
160
183
144
645
116
90
110
86
64
178


<colgroup><col></colgroup><tbody>
</tbody>

Good Day,
I'm using that formula to populate datas like above which are the minutes
Code:
=SUMIF($D:$D,O27,$J:$J)
and simply I've added to that formula
Code:
=SUMIF($D:$D,O27,$J:$J)/60
to find total hrs. but the result was incorrect.
is there any other way to fix it?
Thanks
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
Whats in O27?
Whats in D?
whats in J?
What did you get, why is it wrong and what did you expect
 
Upvote 0

asyamonique

Well-known Member
Joined
Jan 29, 2008
Messages
1,220
Office Version
  1. 2013
Platform
  1. Windows
Hi,

Column O
Code:
=IF(O1="","",IFERROR(SMALL($D$3:$D$400,COUNTIFS($D$3:$D$400,"<="&O1)+1),""))

Column R
Code:
=SUMIF($D:$D,O2,$J:$J)/60

Column D : ID numbers
Column J : Minutes

Thanks
 
Upvote 0

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
OK that was the 1st 3 questions (kind of) answered - what does O27 actually show?
You did not tell me what you got, why it was wrong and what you expected?
You have 1 column if values, and want help on a sumif() formula, that has 3 parts to it, what do the other 2 look like?

The thing is, if =SUMIF($D:$D,O27,$J:$J) worked and gives a valid number, then simply dividing that by 60 should also work
=SUMIF($D:$D,O27,$J:$J)/60
 
Upvote 0

Forum statistics

Threads
1,191,117
Messages
5,984,743
Members
439,906
Latest member
Sekiro1899

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top