#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
|
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 |
Mail Merge Calculation Error | Lsbutler2000 | Mail Merge | 1 | 06-22-2007 06:33 AM |