Timesheet with Attandance Codes & Mutiple Nested Functions

Hi Everyone,

I'm creating a Timesheet that has attendance codes in it. I have a nested function working, but it appears that I have one too many criteria.

Here's the formula that partially works:

'=IF(G55="","",IF(G54=$G$37,$H$37,IF(G54=$G$38,$H$38,IF(G54=$G$39,$H$39,IF(G54=$G$40,$H$40,IF(G54=$G$41,$H$41,IF(G54=$G$42,$H$42,IF(G54=$G$43,$H$43,IF(G54=$G$44,$H$44,,IF(G54=$G$45,$H$45,IF(G58="","0:00",IF(G59>=$J$48,$G59-$G55-$I$48,$G58-$G55))))))))

As you can see, it's quite lengthy. I'm seeking a less complex or another formula that works just as well, but can accept all the attendance codes & be used in Excel 2007 & 2003.

I attached a 2007 version for your review.

The (large formula is in Cell G27 & I would like it to extract the codes & it's relevant hours from the Attendance Codes area.

Thanks