View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom
 
Posts: n/a
Default How to convert time to decimal

Multiply by 24


=Hours*24*payrate

format as general or currency

Regards,

Peo Sjoblom

"frankie" wrote:

hi guys..
can you please tell me how to convert 56:36 (addition of daily times in
column) to a decimal format which can be multiplied by hourly salary rate?