View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patrick C. Simonds Patrick C. Simonds is offline
external usenet poster
 
Posts: 343
Default Convert time to fraction of an hour

I have 2 time columns from which I subtract the high time from the low time
to give me the total time elapsed. So if I subtract 12:11 from 12:34 I get
:23 (or 23 minutes). What I need to be able to do is convert that :23 to the
fraction part of the hour. In this case .383