473,473 Members | 1,844 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

how to convert decimal no time format to original time format with query in ms access

11 New Member
Please help me some one.

Real time format

I have Field i.e [worked_Hrs), in that all entries are number time format, so i need convert with query like Original time format below are the example.

All rows like

[worked_Hrs] Query Result (Hours:Minutes)

0.17 as 0.10
0.25 as 0.15
0.50 as 0.30
0.75 as 0.45
1.50 as 1.30

please send me ms access query.


Thank you
Jan 23 '15 #1
5 1536
Rabbit
12,516 Recognized Expert Moderator MVP
If you are looking to convert it to a date time data type: multiply the number by 60, round to the nearest integer, and then use the DateAdd function to add that many minutes to midnight.

If you are looking to convert it to a string: Take the whole number as the number of hours. Take the fractional and multiply it by 60, rounded to the nearest integer as the number of minutes. Concatenate the results with a colon separator.
Jan 23 '15 #2
vijaykk028
11 New Member
i can not understand, please explain in details.
Jan 23 '15 #3
vijaykk028
11 New Member
0.25 query result as 0.15, please send me ms access query
Jan 23 '15 #4
Rabbit
12,516 Recognized Expert Moderator MVP
Which part don't you understand? Please provide more detail.

Sorry, I prefer to guide someone to an answer as opposed to providing full code. Please make an attempt at the solution using the algorithm specified. If you get stuck somewhere, provide the code you tried and describe where you are stuck.
Jan 23 '15 #5
vijaykk028
11 New Member
thank you for your suggestion. i got it now.
Jan 24 '15 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

13
by: Jason | last post by:
Could someone here show me how I would write a vb program to convert decimal ip address to binary? For example a small form with a convert button and a label for the result and a textbox for the...
13
by: muss | last post by:
how to convert decimal number in a hexadecimal number using C? Please help me. Thanks.
0
by: c2h | last post by:
Set the program to the following assumptions: (1) The implied decmal point is at the beginning of the mantissa. (2) "1" represent positive number and "9" represent negative number. (3) Excess 50...
6
by: sweeet_addiction16 | last post by:
hello Im writin a code in c... can sum1 pls help me out in writing a c code to convert decimalnumber to hexadecimal number.The hexadecimal number generated has to be an unsigned long.
11
by: elliotmf | last post by:
Hello, I need a format function for a query that will Convert: Decimal Time to Regular Time. For Example my Database stores 8 Hours and 15 Min as: 8.25000008940697 And now I need a...
0
by: daydreaming | last post by:
Hi all, I need some help to convert the number in science notation format back the normal format. The input xml <?xml version='1.0' encoding='utf-8'?> <product> <price>2.022E9</price>...
2
nirmalsingh
by: nirmalsingh | last post by:
Hai all, i want to convert decimal to time. for example if i have decimal number 09.6 then i need it as 10.00 and also decimal 10.118 as 11.58. How to convert this? Thanx in advance with Cheers...
1
by: Vitaliy | last post by:
Hi I got this wired exception periodically (Python 2.5, Django based application) what does it mean ?
6
by: Jim Mandala | last post by:
Using MS Access 2003 with SQL Server 2005 as a backend: I am trying to automatically check for collisions in a table of appointments with an appointment currenlty being saved from the form...
1
by: pankajprakash | last post by:
Hi, I have a decimal number. I need to convert this decimal value to exponential value. I have a vb.net code to convert from decimal to exponential value is Format(100000, #.0#E-##) . When I run this...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.