Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 05-27-2011, 12:40 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Timesheet formula Windows 7 32bit Timesheet formula Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

For Excel to be able to distinguish weekdays and weekends, you will need to put the date and time into the cells instead of just the time. If that is acceptable then I can give you a formula to do it.
Reply With Quote
 



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 10:38 AM.


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