Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

convert minutes to houre minutes javascript or asp

Posted on 2008-10-26
4
620 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

I've been trying to accomplish this for a while and it just struck me yesterday how to accomplish this task. I have done searches all over the internet looking for ways to email pages from my applications and finally I have done it!!! Every single s…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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…

809 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