If A1 is start time and B1 is end time:

=MOD(B1-A1,1)

(make sure the result in time format.)

Stuart Carnachan wrote:

Would like to calculate no of hours in a specied shift. I can do this until
foe example start time is 22:00 and end time is 04:00 next day - Can somebody
help ?




--
Stuart