Solved

Covert hours

Posted on 2011-03-17
7
322 Views
Last Modified: 2012-05-11
Hi Experts,
Is any way I can covert from 1 hour 30 min to 1.5 hours?

Thanks
0
Comment
Question by:jodstrr2
  • 3
  • 3
7 Comments
 
LVL 3

Expert Comment

by:CarlsbergFTW
ID: 35157029
(minute_value / 60)  * 100 - gives you the percentage , pretty close to your need.
0
 

Author Comment

by:jodstrr2
ID: 35157062
here is my formula in my query
Hours: Format([EndTime]-[BeginTime],"h:mm") but the result is 1:30
0
 
LVL 3

Expert Comment

by:CarlsbergFTW
ID: 35157106
something like this in a select statement :

select ((to_char(sysdate,'hh')) ),((to_char(sysdate,'mm'))/60)*100 from dual

This select worked on ORACLE SQL.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:jodstrr2
ID: 35157116
I'm not use ORACLE SQL, I'm using access 2003
0
 
LVL 3

Expert Comment

by:CarlsbergFTW
ID: 35157123
You can just work with the minute value as specified in my first post. It's basic math (calculating percentage)
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 35157167

in access, use datediff

DateDiff("n", [BeginTime], [EndTime])/60

0
 

Author Closing Comment

by:jodstrr2
ID: 35157228
Thanks so much capricorn1!!!
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now