[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • Last Modified:

Covert hours

Hi Experts,
Is any way I can covert from 1 hour 30 min to 1.5 hours?

Thanks
0
jodstrr2
Asked:
jodstrr2
  • 3
  • 3
1 Solution
 
CarlsbergFTWCommented:
(minute_value / 60)  * 100 - gives you the percentage , pretty close to your need.
0
 
jodstrr2Author Commented:
here is my formula in my query
Hours: Format([EndTime]-[BeginTime],"h:mm") but the result is 1:30
0
 
CarlsbergFTWCommented:
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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
jodstrr2Author Commented:
I'm not use ORACLE SQL, I'm using access 2003
0
 
CarlsbergFTWCommented:
You can just work with the minute value as specified in my first post. It's basic math (calculating percentage)
0
 
Rey Obrero (Capricorn1)Commented:

in access, use datediff

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

0
 
jodstrr2Author Commented:
Thanks so much capricorn1!!!
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now