Use either

=B1-A1+(A1B1)

or

=MOD(B1-A1)


where A1 is start time and B1 is end time, that way workdays stretching over
midnight will work


--

Regards,

Peo Sjoblom

"Bill66" wrote in message
...
I'm trying to create a weekly timesheet in which I enter the time each day
an
employee begins, and the time he quits, then total the hours worked that
shift. Some employees work from the afternoon of one day till the morning
of
the next day. I can't seem to figure out how to make the Sheet calculate
those hours.
Any suggestions?
Bill66