Help on the formulate hours

		Microsoft Office Forums > Microsoft Excel > Excel
Help on the formulate hours

02-11-2011, 04:40 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Help on the formulate hours

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:30 AM.