Calculating Overtime

[sam13484 via OfficeKB.com]

Very much a newbie when it comes to Excel.
I would like to know if there's a way to set up a spreadsheet that will
calculate:

Regular Time - up to 7.75 hours.
Time and a Half - next 2 hours.
Double Time - hours beyond the 9.75 above.

i.e.
Working 4 hours overtime:
7.75 hours - Regular Time
2 hours - Time and a Half
2 hours - Double Time

Being able to adjust the time segments, down to 15 minutes would be really
nice.

Thanks!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200602/1

Hi

Have a look at Chip Pearson's site:
http://www.cpearson.com/excel/overtime.htm

Hope this helps.
Andy.

"sam13484 via OfficeKB.com" <u18348@uwe> wrote in message
news:5b54bb63c0ce9@uwe...
> Very much a newbie when it comes to Excel.
> I would like to know if there's a way to set up a spreadsheet that will
> calculate:
>
> Regular Time - up to 7.75 hours.
> Time and a Half - next 2 hours.
> Double Time - hours beyond the 9.75 above.
>
> i.e.
> Working 4 hours overtime:
> 7.75 hours - Regular Time
> 2 hours - Time and a Half
> 2 hours - Double Time
>
> Being able to adjust the time segments, down to 15 minutes would be really
> nice.
>
> Thanks!
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...tions/200602/1