=MOD(end_time - start time, 1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"time formula" <time wrote in message
...
I have to do a time sheet with 10 people on it, some work night and some
work
days.The days are no problems but when it come to the night shift they
start
at 1800 and finish the next day at 0600. I need a formula that will be
able
to do both as they rotate between nights and days. I want it to do both
without having to re format everytime that they change from nights to days
Can anyone help