Why would you want to multiply (B1<A1) by 24, but not multiply the B1-A1
part? If you are going to convert the answer to hours (and format as number
or general), then you'll need to multiply the lot by 24. If you are going
to format the answer as time then you don't need to multiply any of it by
24.
--
David Biddulph

"Shariq" wrote in message
...
Hi There!
so in cell C you write this =B1-A1+(B1<A1)*24 AND REPEAT THIS IN C2, C3,
...
TRY THIS I HOPE IT WILL HELP
SHARIQ

"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