View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
taylor taylor is offline
external usenet poster
 
Posts: 32
Default Calculating productivity by time

I'm presented with time in [h]:mm:ss format, ie. 856:25:57, and with a total
productivity number, ie. 1257. Is there a formula to calculate how many per
hour, given this format? If not, what is the best way to convert that
cumulative time into a decimal?