Convert time totals to decimal

NickAC

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?

jmyzk_cloudsmart_jp

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

https://app.smartsheet.com/b/publish?EQBCT=3b2c941231d0415bad4e768afeb0a897

NickAC

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.

jmyzk_cloudsmart_jp

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

https://app.smartsheet.com/b/publish?EQBCT=3b2c941231d0415bad4e768afeb0a897

NickAC

Awesome, thank you!

jmyzk_cloudsmart_jp

Happy to help!😁