SOLVED

Time Conversion to Decimal

%3CLINGO-SUB%20id%3D%22lingo-sub-2938309%22%20slang%3D%22en-US%22%3ETime%20Conversion%20to%20Decimal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2938309%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20set%20up%20a%20formula%20to%20convert%20times%20to%20decimal%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20attached%20sample%2C%20I%20have%20times%20in%20Column%20B%20and%20want%20to%20convert%20those%20times%20to%20decimal%20for%20payroll%20purposes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%20B3%20is%2010%20hours%2030%20minutes.%26nbsp%3B%20(I%20know%20the%20result%20in%20decimal%20should%20be%2010.50%20but%20I%20don't%20know%20how%20to%20create%20the%20conversion%20formula)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2938309%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2938337%22%20slang%3D%22en-US%22%3ERe%3A%20Time%20Conversion%20to%20Decimal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2938337%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F109315%22%20target%3D%22_blank%22%3E%40Robert%20Hart%3C%2FA%3E%26nbsp%3BMultiply%20by%2024.%20I.e.%20in%20C3%20%3CEM%3E%3CSTRONG%3E%3DB3*24%3C%2FSTRONG%3E%3C%2FEM%3E%20and%20copy%20it%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

How can I set up a formula to convert times to decimal?

 

In the attached sample, I have times in Column B and want to convert those times to decimal for payroll purposes.

 

Example: B3 is 10 hours 30 minutes.  (I know the result in decimal should be 10.50 but I don't know how to create the conversion formula)

2 Replies
best response confirmed by Robert Hart (Occasional Contributor)
Solution

@Robert Hart Multiply by 24. I.e. in C3 =B3*24 and copy it down.

Thank you so much!!