Format & calculate time sheet template

[Guest]

I'm building a time sheet template to calculate hours worked each day and pay
period. My problem is setting up cell formatting to recognize a 3pm to
1:30AM shift, that will work in the calculations.

 

[RagDyer]

Try this:

=MOD(B1-A1,1)

With start in A1, and end in B1.

 

[Guest]

RD,
You're the Greatest!
Tks,
Ron

Try this:

=MOD(B1-A1,1)

With start in A1, and end in B1.

 

[RagDyer]

Appreciate the feed-back.