• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

formula need for calculation [SOLVED]

Hi,


I have corrected the changes


Kindy find the below link if it is possible to merge the L & M column in single cell (Which contains formula)


https://www.dropbox.com/s/vukqsk070x4k719/finalworkings.xls?m
 
Hi ,


You can always combine the two formulae into one :


=IF(K3>=TIME(1,0,0),SUM(IF($A$3:$A$27=I3,IF($B$3:$B$27=J3,$C$3:$C$27,0),0)),0)


entered as an array formula , using CTRL SHIFT ENTER , into M3 , and copied downwards.


Please note that I have not checked your calculations ; I would urge you to verify them for all possible values of start and end times.


Narayan
 
You must log in or register to reply here.
Back
Top