If you don't want to have to worry about changeing the formatting manually,
you could also try:

C1=VALUE(TEXT(((B1-A1)*24),"0.00"))

Where B1="11:30" and A1="7:15"

Thanks,
Mike

"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 from http://www.teranews.com