• 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.

If function problem

P

pradeepthota

New Member
Hi,


I have a problem with if statement now I want to select in a time sheet data if the shift is third one( 22:00:00 to next day morning 07:00:00) then I need to see select such that if shift=third, then the date for that record should be the previous one and not the actual data. Can some one help me on this.
 
Pradeepthota


What cells contain what values that are relevant to this ?


ie: Shift Start or End?
 
pradeepthota,

Probably you can have a look at

http://chandoo.org/forums/topic/shiftless-worksheet-fill-shift-cell-based-on-time-cell
 
You must log in or register to reply here.
Back
Top