This is a generic formula and it will work, just put in the shift times and
replace B2 with the cell you put in the end time and A2 with the start time

--
Regards,

Peo Sjoblom

(No private emails please)


"Gene Mah" wrote in message
...
The problem is I have at least 30 employees and only a few will work until
12:30 AM. And it is not the same employees from week to week. I would
like
a scheduler that I can just plug in the shift times and it automatically
figures out the amount of time worked. I have a worksheet made and could
attach it for you to review.
Thanks.
Gene


"Arvi Laanemets" wrote:

Hi

With start time in A2 and end time in B2:
=B2-A2+(B2<A2)
and format as time.

When there is no working time which includes midnight, then you can have
this formula in simpler form:
=B2-A2


When using result of either formula in further calaculations, multiply it
by
24. P.e. with result in C2, and having hourly fee 10$, you'll calculate
daily fee as
=C2*10*24


Arvi Laanemets


"Gene Mah" wrote in message
...
I am creating a scheduler but am having problems figuring out the
amount
of
time between 6:00 PM and 12:30 AM. It would like it to return a
figure
of
6.5 hours.
Thanks.