View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Multiply by 24, it is giving you time not 10ths.

--
HTH

Bob Phillips

"Laurie" wrote in message
...
I'm using Excel 2003 - I have a text formula (=TEXT(I14-H14,"h.m")) that

I'm
using. The times that I have it calculating are 8:00 AM - 5:30 PM which
should be 9.5 hours however it's calculating in 10ths and giving me 9.30
instead. How do I get it formatted to give me 9.50 instead of 9.30?

I'm not a Excel "guru" and have looked up most of my formulas on microsoft
help.

Please help.

Thanks!