I have one sheet in which i enter manually all expenses daily basis. now in another sheet i want all summary from selected date. In manual entry sheet
Date | Flat Block No.| Type | Description | Debit Amt | Credit Amt |Balance
18-11-13 | A | banking | Cheque Deposit | 0.00 | 5000.00 |...
hi. i am creating downtime tracker automate dashboard.
now in "DATA" sheet i enter start time start date and end time and end date
and set formula to calculate total duration time in hours and minutes.
i am getting also the same. but now in "Forecast & Penalty deduct Amt" sheet
i use formula to...
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...
Dear Sir,
I am creating new Network costing file. And i am unable to find out down time % from overall sum of down time. Please help and guide me.
Attaching here excel file for your ref.