#1
|
||||
|
||||
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? |
#2
|
||||
|
||||
Assuming that all dates are working days (as implied in your question), the formula would be
Code:
=(B1-A1)*8/24 The cell containing the formula should be custom formatted as [hh]:mm |
#3
|
||||
|
||||
That's exactly what I need. Thank you for your help.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Actual working hours per day | climbatron | Project | 2 | 12-17-2015 03:13 PM |
help with formulate refers to values | meninio | Excel | 11 | 01-26-2011 10:00 AM |
Formulate month in Excel 2010 | meninio | Excel | 4 | 01-25-2011 12:13 PM |
Convert hours in decimal | ghostones | Excel | 1 | 12-29-2009 09:17 PM |
Need urgent help .. lost 6 hours of work .. assignments due in tomorrow | Phatmat | Word | 1 | 10-15-2009 08:38 AM |