Next time use the word "please" as well

=MOD(end-start,1)

will give you a correct time value if start is before midnight and end is
after.

--


Regards,


Peo Sjoblom

"Sanjay Raut" <Sanjay wrote in message
...
When I try to calculate the overtime of the Evenign AND Night shift the
time
will not calculate exactley..
give me some 1 formula which show me the different of the time between
login
and logout.