Solved

convert minutes to houre minutes javascript or asp

Posted on 2008-10-26
4
623 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
[X]
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
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Article by: DanRollins
This article describes a JavaScript program that creates a maze made of hexagonal cells.  In Part 2 (http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/A_7850-Hex-Maze-Part-2.html), we'll extend the program by adding a depth-…
The task A number given should be formatted for easy reading by separating digits into triads. Format must be made inline via JavaScript, i.e., frameworks / functions are not welcome. So let’s take a number like this “12345678.91¿ and format i…
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…

738 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