Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-11-2011, 03:09 AM
Snvlsfoal Snvlsfoal is offline Help with 'hours worked' calculation... Windows XP Help with 'hours worked' calculation... Office 2004 for Mac
Banned
Help with 'hours worked' calculation...
 
Join Date: Jul 2011
Posts: 9
Snvlsfoal is on a distinguished road
Default Help with 'hours worked' calculation...

Hi,

I have a query about calculating the numbers of hours worked using a formula.

In essence I have a start and end date/time which I can happily subtract from each other to get a the number of hours. BUT, I want to be able to automatically calculate the amount of time spent between two times BUT only where it falls in a 8am - 4pm range.

For example, if a user starts a piece of work at 3pm on 1 day and then continues it the next day from 8am and finishes at 10am I want to be able to make sure it calculates this as 3 hours and not 19 hours which it would do with a straight subtraction.

Does this make sense?

Regards
Reply With Quote
  #2  
Old 08-11-2011, 05:54 AM
Catalin.B Catalin.B is offline Help with 'hours worked' calculation... Windows Vista Help with 'hours worked' calculation... Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

why don't you substract 16/24 from the difference between start and end date like this: =(F3-E3)-16/24
you may need to particularize the format of the result cell to show days and hours between those 2 dates: dd. hh:mm
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook cannot open error messages no fixes have worked so far safogel Outlook 4 03-02-2017 11:19 AM
NETWORKDAYS calculation for entire column Salient Excel 0 07-11-2011 03:58 PM
Finding where I last worked on a document. Balliol Word 1 11-24-2010 04:50 AM
how to make fields calculation variable according to the filter i use duraid Project 0 09-09-2010 01:05 PM
Help with 'hours worked' calculation... Mail Merge Calculation Error Lsbutler2000 Mail Merge 1 06-22-2007 06:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:02 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