From To Rate
Mon- Fri 8.00 18.00 S/T
18.00 20.00 T/Half
20.00 6.00 D/T
6.00 8.00 T/Half

Saturday 8.00 13.00 T/Half
13.00 8.00 D/T

Sunday 8.00 8.00 D/T

Therefore when I complete a timesheet and someone who has basic hours of
07:00 - 16:00 but works overtime (mon-fri) to 20:00 I need to input a formula
to calculate the difference between single time and time/half.

"Mangesh Yadav" wrote:

Give an example (complete with input and output) of what you are trying to
acieve.

Mangesh


"AHurd" wrote in message
...
Timesheet Formula: I am trying to create a formula to calculate whether
the
hours used are either time and a half between x-y hours. Completely
useless
on Excel.