You can subtract the start time from the end time and then multiply
the difference by 24. E.g.,

=(E3-D3)*24

If it is possible that the start time is greater than the end time
(e.g., crossing Midnight, start and 10PM and end at 3AM) use formula
like the following:

=(E3-D3+(D3E3))*24

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Wed, 20 May 2009 14:08:00 -0700, Matt
wrote:

In cell F3 I am trying to get the hours work from the start time in cell D3
and the finish time in E3. I can not locate the forulma for this?