Dear All,
I have the following sample Monthly OT Hour(Aggregated) which I need to covert as follows:-
Could somebody help me out with the formula pls?
Sample data set along with the desired results as follows:-
30:50:00=31:00
30:29:00=30:00
Regards
Dear All,
I do have a sample data set from A1:D7 as follows:-
<tbody>
Region
Vertical
01-Dec
02-Dec
A
FMCG
10
12
A
FMCG
15
18
B
FMCG
20
16
B
Staples
25
29
C
Staples
30
38
C
FMCG
35
47
</tbody>
I would like to carry out the sum conditionally & the lay out is as follows spread...
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.