Forum Discussion

KHarris176's avatar
KHarris176
Copper Contributor
Aug 23, 2020

Converting Time into Percentages

I am creating an excel sheet to help simplify payroll. My hours and minutes is not converting to a percentage. For example, start - 7:00 am, stop - 11:30 am, 4 hrs and 30 minutes. I want this to be e...
Ramiz_Assaf's avatar
Ramiz_Assaf
Iron Contributor
Aug 23, 2020
make the formatting a number
    • Ramiz_Assaf's avatar
      Ramiz_Assaf
      Iron Contributor
      Aug 23, 2020
      KHarris176
      use this formula
      =(C5-B5)*24
      in cell D5
      • KHarris176's avatar
        KHarris176
        Copper Contributor
        Aug 23, 2020

        you are a genius, and I really need to become more proficient in excel. Thank you so much! Ramiz_Assaf 

Resources