Excel Help !!

[gaurav das]

Dear Sir,

I am creating one downtime dashboard, now am not getting one solution. Please help me on that.
In sheet 2 i have raw data and in sheet 1 i want total sum of the given criteria.

In sheet i have set days like " 1 , 2 , 3 .. . . . ."
Now i want from sheet 2 total downtime of same day.

Please find the attached file for your ref.

 

[bobhc]

Your post says nothing about your problem, “Excel help” is why this board is here, if you give a descriptive tile then you stand more chance of getting the right help. Members have busy lives to live and do not spend all their time trawling through the posts.
Please read:-

http://chandoo.org/forum/threads/new-users-please-read.294/
http://chandoo.org/forum/threads/help.12141/

You have two time totals in Sheet two (why does no one ever name the sheets)Hours and minutes and minutes!! which do you want and where in all the columns in sheet one that you have named do you want the time, why not just do a cell reference?

Why have you set up a Poll on the question? Why have you set up a Poll with two check box's that both show "A" and do not show any poll choices even on such a question.

 

[NARAYANK991]

Hi Das ,

To add to what has been posted , I have two points :

1. The raw data which is shown on Sheet2 is presumably all entered manually ; you can easily reduce the amount of data entry and data redundancy by entering only the essential data and deriving all other data using formulae. For example , the data in columns K , L and M can be derived from the dates entered in column Q.

Similarly , the data in columns V and W can be derived from the data entered in columns Q , R , S and T.

2. You want Sheet1 to display the downtimes day-wise ; since a lot of downtimes start on one date and end on another , how do you want the time to be apportioned ? This calculation will not be so simple. Is it possible that the downtime can extend over many days ?

Narayan