Dear all
I have a sPecific Problem. Of converting Decimal to Hours and minutes. I have Searched for the specific Topic in Mibuso , but i dont get what am searching for...
In the Table The Time Value saved is Properly updated like for half an hour it is 30 , for 1 hour 15 minutes it si saved as 1.15 but in decimal ... now the problem is again if iwant that to calculte and show in report it is displaying in decimal
for eg:
30 Minutes + 45 Minutes = 1 hrs and 15 Minutes (1.15 should come ) but system calculate it as .75. How to convert it to Hours basis. Expecting your valuble guidence////
0
Comments
I personally would always encode like this:
15 minutes = 0.25
30 minutes = 0.5
45 minutes = 0.75
1 hour = 1
1 hour 15 minutes = 1.25
This way you can just add your decimals and get the correct result.
45 minutes + 30 minutes = 0,75 + 0,50 = 1,25 = 1 hour 15 minutes
If you want to go with your solution you will need to create a calculation function which does the maths for you (shouldn't be too hard either).
FD Consulting