SOLVED

Time Conversion to Decimal

Copper 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 (Copper Contributor)
Solution

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

Thank you so much!!
1 best response

Accepted Solutions
best response confirmed by Robert Hart (Copper Contributor)
Solution

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

View solution in original post