I'd make sure that the other position pays what you need and then tell them the truth that you understood that it was for 40 hours and you can't financially afford to stay with them. As Keith said don't agree to things because you feel guilty and because they are nice.

I hope you can sort something out