CONVERT DECIMAL TO TIME | WordPress.org

Resolved Graicifyd
(@graicifyd)

3 years, 5 months ago

Please could you help me with a formula to convert decimal number to a time in MM:SS?

If for instance the total number of minutes is – 7.45 minutes fieldname1, I want fieldname 2 to return 07:27.

Thanks in advance.

Viewing 3 replies - 1 through 3 (of 3 total)

Plugin Author codepeople
(@codepeople)

3 years, 5 months ago

Hello @graicifyd

The following link describes the mathematical operations you should to implement:

https://www.calculatorsoup.com/calculators/time/decimal-to-time-calculator.php

Best regards.

Thread Starter Graicifyd
(@graicifyd)

3 years, 5 months ago

Thank you! One more thing. If I wanted to multiply the right side of the decimal by a number, for instance

.45*2

How can I do it?
Plugin Author codepeople
(@codepeople)

3 years, 5 months ago
Hello @graicifyd

It is only mathematics. If X = 7.45, and you want only the decimals, you should use the FLOOR operations as follows: X-FLOOR(X)
```
7.45-FLOOR(7.45)=
7.45-7=
0.45
```
Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘CONVERT DECIMAL TO TIME’ is closed to new replies.

In: Plugins
3 replies
2 participants
Last reply from: codepeople
Last activity: 3 years, 5 months ago
Status: resolved