Hello,
In my Access report, I have a minutes field in the detail line. How
do I convert that minute to hour and minute. The problem for me now
is if I take the minutes, say 75 divide by 60, it gives me 1.25; or
90/60 = 1.50. These are not what the user wants.
They want to have hour and minutes, say 75 minutes, needs to convert
to 1.15 (1 hour 15 minutes); or 90 minutes to 1.30, and so on.
Are there any easy way to do it? Thanks in advance,
James
2  32865 
Use Integer division to get the whole hours, and Mod to get the left over
minutes:
=[Minutes] \ 60 & Format([Minutes] Mod 60, "\:00")
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"James P." <ha*********@ya hoo.com> wrote in message
news:f4******** *************** ***@posting.goo gle.com... Hello,
In my Access report, I have a minutes field in the detail line. How
do I convert that minute to hour and minute. The problem for me now
is if I take the minutes, say 75 divide by 60, it gives me 1.25; or
90/60 = 1.50. These are not what the user wants.
They want to have hour and minutes, say 75 minutes, needs to convert
to 1.15 (1 hour 15 minutes); or 90 minutes to 1.30, and so on.
Are there any easy way to do it? Thanks in advance,
James
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message news:<41******* *************** *@per-qv1-newsreader-01.iinet.net.au >... Use Integer division to get the whole hours, and Mod to get the left over
minutes:
=[Minutes] \ 60 & Format([Minutes] Mod 60, "\:00")
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"James P." <ha*********@ya hoo.com> wrote in message
news:f4******** *************** ***@posting.goo gle.com... Hello,
In my Access report, I have a minutes field in the detail line. How
do I convert that minute to hour and minute. The problem for me now
is if I take the minutes, say 75 divide by 60, it gives me 1.25; or
90/60 = 1.50. These are not what the user wants.
They want to have hour and minutes, say 75 minutes, needs to convert
to 1.15 (1 hour 15 minutes); or 90 minutes to 1.30, and so on.
Are there any easy way to do it? Thanks in advance,
James
Thank you very much, Allen. It works like a champ!
James This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Christine Lawrie |
last post by:
I have an Access 97 database that has graphs installed on a PC with
both Office 97 and Office 2000. I know other people are aware of this
- the database automatically uses Graph 2000 instead of Graph 97. The
Graph objects in the database were automatically converted to Graph
2000 objects, even though they were created in Graph 97. This creates
huge problems with some of the reports that use complex graphs,
because the computer runs out...
|
by: Karen |
last post by:
Anyone that may be able to help.
I have MS Access 2000 installed. I need to convert some MS Access 2002
database files to MS Access 2000 needed for a course. Does anyone know how
to convert? I tried but just get an error message to upgrade, but the MS
website says this can be done.
Thanks anyone.
|
by: KEMDignam |
last post by:
I have upgraded my computer to Access 2003, but I have not converted my
databases since all of my clients still use Access 2000. I need to
create a new MDB, but Access is telling me that I will have to convert
the database to 2003 before it will make an MDB. What are my options?
If I convert the database, I assume that Access 2000 and A2k runtime
will no longer be able to read the MDE. Can I re-install A2k on my
machine? Is there...
|
by: Paul |
last post by:
Is it possible to run an Access 2000 database on a PC with only Access97 installed?
I.e. Could you use a Access 2000 runtime ?
|
by: google0 |
last post by:
I know this is a trivial function, and I've now spent more time
searching for a surely-already-reinvented wheel than it would take to
reinvent it again, but just in case... is there a published,
open-source, function out there that takes a string in the form of
"hh:mm:ss" (where hh is 00-23, mm is 00-59, and ss is 00-59) and
converts it to an integer (ss + 60 * (mm + 60 * hh))? I'd like
something that throws an exception if hh, mm, or ss...
| | |
by: Stumped |
last post by:
I'm using Access 2000 on a Dell PC with 256MB of RAM, and it freezes
up almost immediately after opening the database. The database is on an
internet server, but no-one else who connects notices any problems,
it's only on this PC.Actually its a refurbished PC, the original
Dell(same model) worked perfectly. But now as stated, upon opening the
DB, or opening a table/query/report in print preview it freezes up for
a couple of minutes. Then...
|
by: NEWSGROUPS |
last post by:
I work for an organization that is migrating from Access 2000 to Access
2003. About 5 or 6 years ago we migrated from Access 97 to Access 2000 with
no problem. Will I have trouble converting these already converted databases
to Access 2003? We also have 2 mda's, will these convert with no problem in
the mda format. We no longer have the mdb that made the mda. Are there any
other nuances that I need to look out for?
Thanks in advance,...
|
by: ThePhenix |
last post by:
Hi everybody,
I have recently been doing a conversion for my boss for a access 2000 database (both front and backend) to a MSSQL backend.
I finished the conversion today (as quite a lot of the code / queries ran slow due to access running the queries locally rather than on the server). And tested it on my and my boss's machine with no problems so he gave the go ahead to update everybody to our new mssql 2000 backend with the modified...
|
by: NEWSGROUPS |
last post by:
I am in the midst of trying to convert about 25 Access 2000 to Access 2003.
The new environment consists of Office/Access 2003 and Outlook 2003. When
converting the back ends I have no problems. When converting the front ends
I get the following issues and error. If I try to import all the objects
into a blank Access 2003 shell I get a missing reference error for Outlook
2000, Excel 2000, and Word 2000 or after importing all the objects...
|
by: George |
last post by:
Hello........I have a problem adding up record entries with more than 24
hours when the fields are formatted as hour/minute (h:m). If the actual
summed total of all records is greater than 24 hours, then the hour part of
the answer is truncated to a number less than 24 based on however many
multiples of 24 were part of the summed answer (clear as mud?).
I anticipate the soulution involves either formatting the time field in a
manner that...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
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 we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
