Hi David,

yes the times have been entered incorrectly - unfortunately I'm working from
someone elses data so they have been entered as 1600 instead of 16:00. I'll
change them and try again!

Thanks

Clare

"David Biddulph" wrote:

I wonder whether you entered your times correctly? Remember that Excel
times are entered as 16:00 and 06:30, not 1600 and 0630.
--
David Biddulph

"devoted_darling" wrote in
message ...
Hi David,

Thankyou for your reply, however the formula brings back 0 when it whould
bring back a number as it's calculating the hours worked between the 2
hours
posted.....

Any ideas?

Clare

"David Biddulph" wrote:

=MOD(B1-A1,1)
--
David Biddulph

"devoted_darling" wrote in
message ...
HI, HELP!

I'm trying to generate the formula to subtract 24hr time clocks. If I
want
to work out the hours between 0500 and 1600 then it's a simple case of
subtraction - however, the problem is when I try and reverse this. I'm
trying
to calculate a formula to work out the hours between, for example, 1600
and
0630 - the formula I've tried using doesn't work so is obviously wrong.

Please help!