Solved

convert minutes to houre minutes javascript or asp

Posted on 2008-10-26
4
619 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

ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Trying to redirect after event in javascript 3 23
add a 3rd selection to sum 7 28
how can i make the array into an object? 4 31
Select case on click 3 15
This article shows how to create and access 2-dimensional arrays in JavaScript.  It includes a tutorial in case you are just trying to "get your head wrapped around" the concept and we'll also look at some useful tips for more advanced programmers. …
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
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…

770 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