|Let me see if I can come up with a short synopsis of your most recent post:|
"I'm getting errors. Please help."
Since I can't see your machine from where I'm sitting, am I supposed to simply guess at what errors you are getting and come up with a solution based on that guess?
Whether I manually type in your example "Actual Paid" times into a series of cells or calculate those times by using =B1-A1, where B1 and A1 contain times, I can use =40/24-SUM(times) and get the results you want.
Granted, by simpling entering =40/24-SUM(times) in a cell I will get 0.320138889 from your example, but as soon as I format it as [h]:mm I'll get 7:41.
I really don't know what else to tell you.