Hours Breakdown to Normal Time, T5 & DT

1. Hours Breakdown to Normal Time, T5 & DT

Hi,

Sorry this is probably an easy one but having alittle trouble working it out.

I have daily hours that I need to break down to normal time, time & half and Double time.

Normal Time = upto 8 hours
Time & Half = upto 2 hours after first inital 8hrs
Double Time = anything over 10hrs for day

Date Hrs NT T5 DT
5/9/12 11.50 8 2 1.50
5/9/12 7.50 7.5
6/9/12 9.00 8 1
6/9/12 10.00
6/9/12 12.00
6/9/12 12.00
8/9/12 10.00
8/9/12 10.00

Cheers,
Ral

2. Re: Hours Breakdown to Normal Time, T5 & DT

Sorry just realised that I need to break it down based on a day as well.

The able listed breakdown is for Monday to Friday work.

if they work on a saturday it is:
Time & Half = First 2 hours
Double Time = anything after the first 2 hrs

Working sunday is all Double Time

3. Re: Hours Breakdown to Normal Time, T5 & DT

Hi Rallie1982

Is this something that you could work with! The sheet is for decimal time, not normal time.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1