Thread: how do i change hours and minutes into a decimal number?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Mills00 Mills00 is offline
external usenet poster
  
Posts: 2
Default how do i change hours and minutes into a decimal number?
i am trying to turn total flight hrs into a decimal number( ie: 2045hrs
10mins into 2045.10). can anyone help me with a formula which may help in
this? time is given HH:MM but i need it turned to HH.M.
Reply With QuoteReply With Quote