View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Graham F[_2_] Graham F[_2_] is offline
external usenet poster
 
Posts: 4
Default Time as a fraction

Hi Group,

I need to express total time as a fraction, for example Excel shaws the
result of a time calculation as 8:30 which is eight hours and thirty minutes,
I need to have it as 8 1/2 or 8.50 hours, is this possible? Many thanks for
any help. Grahamj