Total Hours: IIf([Time]="All Day",[Work Days]*7.4,[Work Days]*3.7)
So what I am looking to return in English is: If the time entered in the Time field is All day then multiply the figure in the Work Days field by 7.4. If the entry in Time isn't All Day then multiply the figure in the Work Days field by 3.7
Bet I'm missing something brutally obvious.
Been too close to this for too many hours.
Thanks in advance
Guinness
So what I am looking to return in English is: If the time entered in the Time field is All day then multiply the figure in the Work Days field by 7.4. If the entry in Time isn't All Day then multiply the figure in the Work Days field by 3.7
Bet I'm missing something brutally obvious.
Been too close to this for too many hours.
Thanks in advance
Guinness