Hi!

Try this:

A1 = start time = 3:00 PM
B1 = end time = 3:00 AM

For a result of 12:00 format the cell as [h]:mm and use this formula:

=B1-A1+(B1<A1)

For a result of 12 format the cell as GENERAL and use this formula:

=(B1-A1+(B1<A1))*24

Biff

"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