Results 1 to 1 of 1

Thread: Mean time calculation

  1. #1

    Mean time calculation



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi friends, My Data looks like


    A B C
    01/01/2015 21:23:01 0

    01/01/2015 09:23:01 1 01/01/2015 09:23:01

    01/01/2015 08:23:01 0

    01/01/2015 07:23:01 1 01/01/2015 21:07:01

    01/01/2015 21:23:01 0


    means, whenevr the value in column 'B' is 1, then relevant column 'A' data will be transfered to column 'C'
    so, my worry is to calculate the mean time between the two dates in the column 'C' with the static formula, (I can't use the normal cell minus formula)

    and sometimes, I may get only one datetime value in the column 'C' as condition is false in column 'B'.

    Please help me to solve this, I tried my level best, but i got exhausted.

    please find the attached picture, where you can understand well, if this is not understandable

    Thanks
    Ganesan
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Mean time.jpg 
Views:	15 
Size:	69.4 KB 
ID:	3481  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •