Solved

convert minutes to houre minutes javascript or asp

Posted on 2008-10-26
4
621 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 Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Print Rhino Java Array in Javascript 1 30
Wordpress and Wufoo 1 36
Display if field is NOT "" or NOT null 6 21
javascript and jquery question 4 20
Introduction HTML checkboxes provide the perfect way for a web developer to receive client input when the client's options might be none, one or many.  But the PHP code for processing the checkboxes can be confusing at first.  What if a checkbox is…
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…

679 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