# Convert time totals to decimal

Options
✭✭✭

Hello,

I need a formula to convert a total number of hours, minutes, and seconds worked on a monthly basis into a decimal form so it can be totaled. The "Hours Worked" column has data I imported from excel that looks like this: 174:23:00

Any thoughts on the exact formula for this?

• ✭✭✭✭✭✭
Options

Hi @NickAC

=VALUE(LEFT(Time@row, FIND(":", Time@row) - 1)) + VALUE(LEFT(RIGHT(Time@row, 5), 2)) / 60 + VALUE(RIGHT(Time@row, 2)) / 60 / 60

• ✭✭✭
Options

I tried this formula but it adds another 0 behind the total hours and ignores the minutes.

=VALUE(LEFT([Hours Worked]@row, FIND(":", [Hours Worked]@row) - 1) + VALUE(RIGHT([Hours Worked]@row, 2)) / 60)

For example, it converts 176:05:00 to 1760.00, but I'd be looking for something closer to 176.05.

• ✭✭✭✭✭✭
Options

Hi @NickAC

=VALUE(LEFT(Time@row, FIND(":", Time@row) - 1)) + VALUE(LEFT(RIGHT(Time@row, 5), 2)) / 60 + VALUE(RIGHT(Time@row, 2)) / 60 / 60

• ✭✭✭
Options

Awesome, thank you!

• ✭✭✭✭✭✭
Options

Happy to help!😁

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!