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

You would have to convert to decimal hours for that, by multiplying by 24.

--
HTH

Bob Phillips

"C A" wrote in message
...
I'm working on creating a weekly time sheet log. I have the formulas all

set
up, but the total times need to be formated for quarter hours. (Where I

need
it to show "7.5" it shows "7.30")

Thanks,
Cynthia