Need IF formula to show o/t and

Microsoft Excel 2004 for mac
January 28, 2011 at 05:14:54
Specs: Macintosh
After 5 years, my bosses can't decide if I get paid for lunch or not BUT they do agree that I get a set salary for working between the hours of 9AM and 6PM. So I want to adjust my time sheet formula to only show the hours over or under this schedule.

EX: IN @7:30 AM, OUT@ 6:00 PM = +1.5 Hours

EX: IN @ 8:00 AM, OUT @ 3:00 PM = -2.0 Hours

See More: Need IF formula to show o/t and

Report •

January 28, 2011 at 10:06:13
With your IN time in A1 and Out time in B1, try this:


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question