Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1.1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 327 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 994 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
need to convert Time Vale saved as Decimal back to time
southindian
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////
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