follows-

  1. X

    Convert Total OT Hour Conditionally?

    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
  2. X

    How To Sum Conditionally From Vertical Layout To Horizontal Layout?

    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'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
Back
Top