Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-26-2011, 02:34 PM
IndCom IndCom is offline Timesheet formula Windows XP Timesheet formula Office 97
Novice
Timesheet formula
 
Join Date: May 2011
Posts: 8
IndCom is on a distinguished road
Default

Bear in mind that somedays are 12 hour shift days that are REGULAR WORKED HOURS.



Basically, in my case

Saturday & Sunday= 12 hour shifts & are REGULAR HOURS
Thursday & Fridays= 8 hour shifts and are REGULAR HOURS
This makes a 40 hour workweek of REGULAR HOURS.

Anything over this 40 hours is considered OVERTIME HOURS. But, I'm trying to break it down into a daily log basis, or have it show as "0.0" for any OVERTIME that day.


Now I know I've confused the issue.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Timesheet formula PMT Formula OneOleGuy Excel 4 03-05-2011 09:54 AM
Timesheet formula Help with Formula Corca Excel 6 02-22-2010 09:40 PM
Timesheet formula Timesheet formula help beardking Excel 2 11-10-2009 02:06 AM
Timesheet formula If formula sixhobbits Excel 1 10-02-2009 08:02 AM
Help for formula dehann Excel 5 05-01-2009 10:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft