Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-11-2011, 04:35 AM
meninio's Avatar
meninio meninio is offline Help on the formulate hours Windows XP Help on the formulate hours Office 2010 32bit
Novice
Help on the formulate hours
 
Join Date: Jan 2011
Location: Brasil
Posts: 15
meninio is on a distinguished road
Default Help on the formulate hours


Good morning!

I need a formulate that calculates a value between a period of hours, which are being added daily 8 hours.
Ex: 11/02/2011 to 14/02/2011 instead of bringing the result 48 hours show 24 hours, which are the 3 working days.

Someone tell me if is possible?
Reply With Quote
  #2  
Old 02-11-2011, 04:40 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Help on the formulate hours Windows 7 32bit Help on the formulate hours Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Assuming that all dates are working days (as implied in your question), the formula would be

Code:
=(B1-A1)*8/24
Where A1 contains the start date and B1 contains the end date.
The cell containing the formula should be custom formatted as [hh]:mm
Reply With Quote
  #3  
Old 02-11-2011, 04:56 AM
meninio's Avatar
meninio meninio is offline Help on the formulate hours Windows XP Help on the formulate hours Office 2010 32bit
Novice
Help on the formulate hours
 
Join Date: Jan 2011
Location: Brasil
Posts: 15
meninio is on a distinguished road
Default

That's exactly what I need. Thank you for your help.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Actual working hours per day climbatron Project 2 12-17-2015 03:13 PM
Help on the formulate hours help with formulate refers to values meninio Excel 11 01-26-2011 10:00 AM
Help on the formulate hours Formulate month in Excel 2010 meninio Excel 4 01-25-2011 12:13 PM
Help on the formulate hours Convert hours in decimal ghostones Excel 1 12-29-2009 09:17 PM
Help on the formulate hours Need urgent help .. lost 6 hours of work .. assignments due in tomorrow Phatmat Word 1 10-15-2009 08:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:07 AM.


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