Time To Decimal

[DEVIMPLOY_Autom]

hello , whoever can help me . I had done it in a pliative so that the time would be converted to decimal to calculate the value of the service.

The result would be 02:00 , but I would have to convert to 2.00 … I made it in a way that I did not need to use virtual columns with seconds , minutes like I saw in some example applications .

I had managed to get the result in Decimal in this formula, but now I don’t remember how I did it.

Who can help!

[Rafael_ANEIC-PY]

Hello Rafael, it’s me, Rafael.

DEVIMPLOY_Automacao:

The result would be 02:00 , but I would have to convert to 2.00 … I made it in a way that I did not need to use virtual columns with seconds , minutes like I saw in some example applications .

I had managed to get the result in Decimal in this formula, but now I don’t remember how I did it.

Well, that expression is a substraction, so the important bits are in how you configured those two columns, so you should check that out to refresh your memory.

After that you could check out the replies to this post:

Convert Duration to decimal Questions

I’m having trouble converting duration to a decimal. Can someone assist with the right expression? I’ve separated the hours from minutes and then attempted to divide the minutes by 60 in order to get the portion of hours but I’m getting the result further below. HOUR([End Date Time]-[Date Time Entered])&"."&(MINUTE(TIME([End Date Time])-Time([Date Time Entered])))/60 [image]