Microsoft Office Forums - View Single Post - Help on the formulate hours

Thread: Help on the formulate hours

View Single Post

Old

02-11-2011, 04:40 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

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