Problem with Time Format of Excel - 2007

Hello,

I'm working with time calculations.

In a cell, if the time shows 9.30, right clicking the cell > Format > General shows the right time in decimal.

1a.JPG

If I go to Format > Custom > h:mm > the time shown is incorrect. Please check the attached screenshot.

1b.JPG

Why does it show different timing? Please help

Hi
I think in your first example excel is treating that purely as a number ie 9 dollars 30 cents or 9.3 average score, when you go custome try hh:mm or AM/PM and see if that resolves the issue.

Chris