need to convert Time Vale saved as Decimal back to time

southindiansouthindian Member Posts: 247
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////

Comments

  • FDickschatFDickschat Member Posts: 380
    This is not really a NAV problem. It is just the way how you store time values in a decimal field.

    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).
    Frank Dickschat
    FD Consulting
Sign In or Register to comment.