Solved

convert minutes to houre minutes javascript or asp

Posted on 2008-10-26
4
614 Views
Last Modified: 2012-08-13
I have recently developed a time log which tracks time worked for a week. My problem is at the end of week time can be up or down i.e -15 min or 125. I need a way to convert the minutes to display as HH:MM
weather the time  IS - OR +. I have tries doing the conversion in SQL USING CONVERT OR CAST, problems arise when the time goes to negative. I am currently showing minutes only as <%=(Recordset1.Fields.Item("remaining").Value)%>
0
Comment
Question by:Camnoc
  • 2
  • 2
4 Comments
 
LVL 7

Expert Comment

by:bluV11t
ID: 22806856
Try showing minutes this way:
(I added some variebles you might need Dim TotalMinutes, hours, minutes somewhere above this code)
<%

TotalMinutes = Recordset1.Fields.Item("remaining").Value

hours = cint(abs(TotalMinutes) / 60)

minutes = abs(totalminutes) - (hours*60)

if TotalMinutes < 0 then response.Write " - "

response.Write right("0" & hours, 2) & ":" & abs(minutes)
 

%>

Open in new window

0
 

Author Comment

by:Camnoc
ID: 22807055
Hi
Thank you for responding so fast.
Seems to work well if the result is < + or -1 hour . When the total minutes  are > + OR - I hour the result is not correct??? Example 90 Min shows 2:30??
0
 
LVL 7

Accepted Solution

by:
bluV11t earned 500 total points
ID: 22807088
Sorry, used wrong function to get integer part of hours:

hours = Int(abs(TotalMinutes) / 60)
0
 

Author Closing Comment

by:Camnoc
ID: 31510078
Thank you very much.
This is fantastic.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Problem to Popup 2 50
Test ddwrt:UserLookup 1 20
ASP Button to clear text 4 16
Cordova Camera plugin fails 2 18
In my daily work (mainly using ASP.net), I need to write a lot of JavaScript code. One of the most repetitive tasks I do are the jQuery Ajax calls. You know: (CODE) I don't know if for you it's the same, but for me is soooo tedious to write the …
JavaScript can be used in a browser to change parts of a webpage dynamically. It begins with the following pattern: If condition W is true, do thing X to target Y after event Z. Below are some tips and tricks to help you get started with JavaScript …
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

707 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

15 Experts available now in Live!

Get 1:1 Help Now