Still wrong, see my reply to your previous post. SHOUTING won't make it
right, and is frowned upon by netiquette.
--
David Biddulph

"Shariq" wrote in message
...
HI CRUSTY 53!

IN CELL C1 ENTER (=B1-A1+(B1<A1)*24) AND COPY DOWN.....
WELL TRY WHAT I'VE SUGGESTED, IT WON'T DISAPPOINT YOU, IT'S EASY AND
SIMPLE
NO NEED TO ENTER BIG LENGHTY FORMULAS IF YOU CAN GET IT DONE WITH A SIMPLE
SMALL ONE, YOU CAN COUNT TIME BY THIS FORMULA, EVEN IF FINISHING TIME IS
INTO
NET DAY, AND WHEN NO TIME IS ENTERED THE C COLOUM SHOWS 0:00, BY THE WAY
YOU'LL HAVE TO FORMAT THE CELLS INTO TIME BEFORE YOU EXPECT YOU GET
DESIRED
RESULTS.

SHARIQ

"crusty53" wrote:

Thanks i tried this and got an# error
but thanks for the try.
i got an answer from garys student that worked so until the next querie
thank u again.

"Teethless mama" wrote:

C1 =(B1-A1)+(A1B1)
copy from c1 down as far as needed

"crusty53" wrote:

i have problems getting correct time.
A B C
1 16:00 00:30
2 15:43 23:49
3 13:55 00:01
In column C i want the time between A & B. But it keeps giving me
15:30
and it should be 8:30 Can anybody help.
The formula i am using is (B1-A1)
A is sign on time
B is sign off time