Assume the start time is in A1 and the finish time in B1, both in
Excel time format, put this formula in C1:

=(B1-A1)*24

Format C1 as a number with 2 dp.

Hope this helps.

Pete

On Sep 18, 10:43 pm, "Ian" wrote:
Hi
I need to do a sheet where I put in a time, 7:15 for example in a cell. In
another cell I would enter 11:30 for example. The difference in time is 4.25
hours. What formula would I use to get this answer?
Thanks for any help

--
Posted via a free Usenet account fromhttp://www.teranews.com