Thanks Pete
I'll try that
Cheers
Ian
"Pete_UK" wrote in message
oups.com...
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
--
Posted via a free Usenet account from
http://www.teranews.com