LinkBack URL
About LinkBacks
Total hours in A1.
In A2 to calculate time & half
=IF((A2-8)>2,2,A2-8)
In A3 to calculate double time
=IF(A2-10>0,A2-10,"")
Total hours in A1.
In A2 to calculate time & half
=IF((A2-8)>2,2,A2-8)
In A3 to calculate double time
=IF(A2-10>0,A2-10,"")
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks