Assistance with multiple IF conditions

[babyjohnson]

Hi All,

I'm in the midst of preparing a time sheet & need some assistance when multiple if conditions are involved;

i.e if an employee from X dept if roaster on them for few days of the week normal working hour are xxhrs & the remaining is overtime

Please find attached my sample spreadsheet with my conditions laid . Appreciate if someone could help me build this multiple conditions in a formula

Thanks in advance
John

[babyjohnson]

Hi ,

yes , but I'm not able to get the formula right when I'm trying multiple if conditions. May be I'm doing something wrong.

Any help with the formula urgently will be of great help

thanks
John

[babyjohnson]

Hi All,

Any thought or help on these multiple if conditions please.

Thanks John

[babyjohnson]

Hi All,

I have built some condition to my files & still require some urgent assistance. Please find attached my revised file.


Thanks John