Thread: Formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Formulas

Nancy

with your time in A1 try

=A1*1440/60

format as general

Mike

"Nancy" wrote:

I am trying to convert minutes into hundreds...I need to show the following
1.15 as 1.25
1.30 as 1.50
1.45 as 1.75
Is there a formula for this conversion?
Thanks,