I just can't solve this! Excel 2010, I have a timesheet where I write day by day the entry time, exit time, lunch time. A cell computes the worked hours, say:
A B C D entry exit lunch worked(=B2-A2-C2) 09.30 18.20 00.15 8:35 09.20 13.10 00.00 3:50 09.30 18.40 00.45 8:25 09.15 18.40 00.30 8:55 ...
Now I sum the worked day and times in the summary cells:
Worked days (=COUNT.NUMBERS(D1:D31)) 13 Worked hours (=SUM(D1:D31)) 99:05 <- formatted as [hh].mm Full hours (=D33*8) 104 <- hours if I had worked full time each day Difference (???)
In the Difference cell I want to know how many hours I have worked more (or less) than the standard 8 hours per day.
A simple difference
=D45-D44 does not work, because the two cells are in a different format. I've tried a lot of conversions and cell formats, with no luck.
The funny thing is that with the previous excel version (2007) it worked! I can't figure this out, thanks.