count hours past midnight

currently i have setup that the spreadsheet takes the clock out time and subtracts the clock in time to get how many hours worked...one issue i have is if someone starts in the PM and leaves in the AM i get an ######## in my total column...cells are formatted as 00:00 AM

any ideas this is what i have which works except for the midnight change

Please Login or Register  to view this content.

Try

=MOD(B1-A1,1)

This will work whether the shift crosses midnight or not

That worked for that but it broke another formula...i had in another cell

Please Login or Register  to view this content.

when i enter the =MOD formula in the Q cell...

Now on the broken formula i am getting #VALUE! as an error

i had a error on the page which was causing it...thank you for the help