You didn't post the layout for your worksheet, so I'll assume you have a
total hours column (say, Column T for this example). Assuming your data
starts in Row 2, use =MIN(T2,4) for your normal hours and =MAX(T2-4,0) for
your overtime hours, so I guess the formula you want would be this...

=MIN(T2,4)+2*MAX(T2-4,0)

--
Rick (MVP - Excel)


"chilson" wrote in message
...
i need to put overtime in a work sheet
but here is what i need to do if you work Between 12:00 am to 8:00 am
this
is double time now how do i calculate these hours as double time

So what i'm saying is if i come to work a 8:00pm and work unitl 4:00 am
i will invoice the company 4 stright hours and 4 double time hours

i want the program to auto calculate this .