View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Converting hour/minutes to hours/hundredths

=A2*24
Format cell to 2 decimal places.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tbazemore" wrote:

I have an excel spreadsheet which has hours/minutes and I need to convert it
to hours/hundredths (example 2:13 to 2.22). Is there a formula to complete
this conversion?

Thank You.