Format & calculate time sheet template
 

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.

Format & calculate time sheet template
 

Try this:

=MOD(B1-A1,1)

With start in A1, and end in B1.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ronnyj105" wrote in message
...
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.

Format & calculate time sheet template
 

RD,
You're the Greatest!
Tks,
Ron


"RagDyer" wrote:

Try this:

=MOD(B1-A1,1)

With start in A1, and end in B1.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ronnyj105" wrote in message
...
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.

Format & calculate time sheet template
 

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ronnyj105" wrote in message
...
RD,
You're the Greatest!
Tks,
Ron


"RagDyer" wrote:

Try this:

=MOD(B1-A1,1)

With start in A1, and end in B1.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ronnyj105" wrote in message
...
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.