Converting Time into Percentages

%3CLINGO-SUB%20id%3D%22lingo-sub-1606707%22%20slang%3D%22en-US%22%3EConverting%20Time%20into%20Percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606707%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20creating%20an%20excel%20sheet%20to%20help%20simplify%20payroll.%20My%20hours%20and%20minutes%20is%20not%20converting%20to%20a%20percentage.%20For%20example%2C%20start%20-%207%3A00%20am%2C%20stop%20-%2011%3A30%20am%2C%204%20hrs%20and%2030%20minutes.%20I%20want%20this%20to%20be%20end%20up%20with%20the%20value%20of%204.5%20not%204.3%20(because%20obviously%2030%20minutes%20is%20half%20of%20the%20hour).%20How%20do%20I%20adjust%20this%20value%20in%20my%20excel%20doc%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1606722%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20Time%20into%20Percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606722%22%20slang%3D%22en-US%22%3Emake%20the%20formatting%20a%20number%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1606732%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20Time%20into%20Percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606732%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746148%22%20target%3D%22_blank%22%3E%40ramizassaf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20doesn't%20change%20the%20value.%20It%20stays%20the%20same%2C%204.3.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1606735%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20Time%20into%20Percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606735%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F768279%22%20target%3D%22_blank%22%3E%40KHarris176%3C%2FA%3E%3CBR%20%2F%3Euse%20this%20formula%3CBR%20%2F%3E%3D(C5-B5)*24%3CBR%20%2F%3Ein%20cell%20D5%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1606737%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20Time%20into%20Percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606737%22%20slang%3D%22en-US%22%3E%3CP%3Eyou%20are%20a%20genius%2C%20and%20I%20really%20need%20to%20become%20more%20proficient%20in%20excel.%20Thank%20you%20so%20much!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746148%22%20target%3D%22_blank%22%3E%40ramizassaf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1606747%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20Time%20into%20Percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606747%22%20slang%3D%22en-US%22%3Eyou%20are%20most%20welcome%20sir%3C%2FLINGO-BODY%3E
New Contributor

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 end up with the value of 4.5 not 4.3 (because obviously 30 minutes is half of the hour). How do I adjust this value in my excel doc?

5 Replies
make the formatting a number

@Ramiz_Assaf 

I doesn't change the value. It stays the same, 4.3.

@KHarris176
use this formula
=(C5-B5)*24
in cell D5

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

you are most welcome sir