MS EXCEL question here for the smartpants out there! =D  

I need to work out how to find the total hours worked from 2 times
that I enter onto an Excel spreadsheet. BUT, the hours are in 24hr
format AND 0815hrs is 08.25, 1930hrs is 19.50, and 2345hrs is
23.75(!!!) I know it seems mad, but that's how it has to be done.

Anyway, the problem is that I can work out that someone worked 3 hours
between 1700hrs and 2000hrs, but if they work past midnight I come
unstuck!!

Any suggestions would be greatly appreciated!  Many thanks... =D

Stick time in in column A and time out in column B.  In column c enter:
=IF(B1>A1,B1-A1,B1-A1+24.00).  Copy and paste down column C.

-anhebetude

Anhebetude - You're a star!!  That works perfectly!! =)

Now I have a new problem.  In the column receiving the formula, if no
time is entered (say for Saturday and Sunday) the hours worked shows
24.00.  Is there something I can add to this formula to stop this?

Many thanks again! =)

(PS Do you get the prize now?) =)

Use the if or statement
=IF(OR(A7="",B7=""),0,IF(B7>A7,B7-A7,B7-A7+24))

Conormul - I bow to your greatness!!  Many, many thanks for that
brilliant formula!! =)