Caluclating And Rounding Time In Asp

I'm trying to calculate two time fields. And when the result is smaller then 15 min, it has to round it to 15 min. Example:

begin time: 14:00
end time: 14:40
(end time - begin time = 40 minutes)
result has to be: 45 minutes

The result wil be shown in a form field. This is the code I'm using (it works fine in my database), perhaps I have to adjust it for asp? But I don't know how. Code:

View Replies


ADVERTISEMENT

Rounding Off

I need to round off a few fields to 1 or 2 decimal places but if the number is negative, it gives -0.0 or -0.00 after rounding off. Eg. -0.001356 after rounding off to two decimal places gives me -0.00...which is meaningless as -0.00 is useless Also, -0.019 should give -0.02.Tried using FormatNumber and Round functions in VBScript but still it gives the same results.

View Replies View Related

Rounding Down/up?

I have a page in witch 4 or so variables are loaded from a database. They are of currency format and then they are add up to get a total. Problem is that say the total is $6.10 the actual return is rounded down to $ 6.1 . How can I get it to show $6.10 , less rounding ??

View Replies View Related

Round() :: Rounding Bug

i have a very simple question which is driving me nuts. Using the ASP function Round():

Why do BOTH Round(1.775, 2) and Round(1.785, 2) both give the exact same result of 1.78 ?

Surely they should give different results, 1.78 and 1.79 respectively.

View Replies View Related

Rounding The Numbers

I'm using asp, obviously, and mysql. My prices are using the decimal field type... what can I do to make it round up the the nearest 5?

View Replies View Related

Rounding Numbers

I've got this script, and its been giving me this result as seen below. 2 questions I would like to ask..

1. How would I modify the below script in order to round the numbers?. (Script further down.)

2.You see the output result where it says 3268.19?, the white space next to it means the 'Parts' record set is blank but did have a weight value, now how would I substitute the word "NA" for the white space being shown? .....

View Replies View Related

Rounding Numbers

I'm trying to work out how I can round off a number that the user inputs. I need the number to round up to the nearest 50. For example, if the user enters 234, I want it to round up to 250. If the user enters 51, I want it to round up to 100. Has anyone got any suggestions for coding?

View Replies View Related

Rounding Numbers Up

I am working on a shipping calculator, and basically need to round up a number to the nearest 1 and am unsure how to go about it, any ideas?

View Replies View Related

Rounding Down Number

If CInt(StrFirst) rounds up the value what rounds down the number i.e just show the whole number with out taking in to account anything after the decimal point?

View Replies View Related

Rounding Decimals 2 Places

Right now I round my number to 2 decimal places... and since I am dealing with money values I need to show $100.70...but my calculations show $100.7. Is there a way to fix this? How can I tack on a "0" if it only shows 1 decimal place?

View Replies View Related

Dividing Variables And Rounding

I'm doing up a stats page for a survey, and this is a small
part of one of the results. Below is part of the code to do
totals/percents. My question is, how do i make it so myAnswer is
written with two decimal places?

Currently, it displays the percent as 4.76190476190476

<%
myAnswer = OneAgree_total / OneTotal_total * 100
Response.Write "" & myAnswer
%>

View Replies View Related

Trimming Or Rounding Up A Number

if i have a value of 11.7908787541713

how could i trim it to 11.79 and how do i round the number up?

View Replies View Related

Rounding On Calculated Field

Is there a way to round a number that is calculated in an sql statement?

1/25/2006 NT NT 10 NT
1/26/2006 450000 NT 10 NT
1/26/2006 200100 5 NT 5
1/26/2006 50000 5 NT 5
Average 233366.6667 5 10 5

On my average row, i dont want any numbers after the decimal point. My sql is Select AVG(XXX) from `test` Where `XXX` <> -1

View Replies View Related

Rounding Of Number To 2 Decimal

how do i round off a number to 2 decimal places? This code taken from www.w3schools.com only round the number to a whole number.

<html>
<body>

<script type="text/vbscript">
i = 48.66776677
j = 48.999
document.write(Round(i))
document.write("<br />")
document.write(Round(j))
</script>

</body>
</html>

View Replies View Related

Rounding To 2 Decimal Places

I have got the total amount of hours flown in the top left hand side of the home page and it is in hours.

Trouble is the decimal places need to be rounded to 2 as sometimes it says sometihg like 3254.63333333333 hours. I'd like it to say something like 3254.63 instead.. Code:

View Replies View Related

Rounding Off To 2 Decimal Places

can anyone help me i want to round off a number entered by a user to two decimal points for a number of text boxes.

View Replies View Related

Num To String Conversion Rounding Issue

I had recently found a function that will write out a currency amount in words. It worked fine until I passed it a variable retreived from the stored procedure.

Well I had to change an "Int()" to "CDbl()" within the function because I got an error: "Variable uses an Automation type not supported in VBScript". I also changed an "(Abs(nAmount)" to an "(Abs(CDbl(nAmount))" because of the same error. Code:

View Replies View Related

Time Calculation :: Difference Between Login And Current Time

I would like to display the difference between the logging time
[Session("start"] and the current time [now]. In hours minutes and seconds,
I have tried a couple of things but all I see is gobbledy gook.

View Replies View Related

ASP To Re-load Page From Time To Time To Reset Varaibles

I have a website that I subscribe to that allows me to track tasks. I have an extra computer with a big monitor that i want to always display the task list. the problem is after so many hours I get logged out.

I need to need to reload that sign in url every few hours Code:

View Replies View Related

Comapring Database Time And Computer Date/time

there i was just windering how do i compare a date/time vlaue in sql server agaisnt the computers' date/time.
for example, if computer date/time is two months or 2 weeks before the database date/time do something

View Replies View Related

Time/Date Format And Changing Time To GMT

Currently working on a ASP for a friend, which requires the date and
time on it. It pulls in entries from an Access Database with dates and
times in the format of:

"Fri Oct 17 18:02:46 2003"
However my date and time on the ASP page is displayed as:
"Friday, October 17, 2003 18:02:46"
using the script:
"<%Session.LCID = 1033%>
<%=FormatDateTime(Date(), vbLongDate)%>
<%Session.LCID = 2057%>
<%=time()%>"

Anyone know how to change this script, fully or partly to produce the
date and time on the format that's in the access database i.e. "Fri Oct 17
18:02:46 2003" Code:

View Replies View Related

Time Convert String To OdbcType.Time

I am working on a database that collects information about incidents. One of the fields that people enter is the time of the incident. I am trying to convert that string that people enter into a OdbcType.Time and I am at a lost.

View Replies View Related

Local Machine Time To Eastern Time

How will we convert the system date & time to other timezone for eg: Eastern Time zone using ASP?

View Replies View Related

Time Function Returns Wrong Time

When the Form is submitted I use the Date() and Time() functions to put the date and time into the Body part of the e-mail. The time reported is three hours earlier than the time at which the Form is actually submitted.

I understand these functions are evaluated on the server so the server must be in a time zone three hours earlier than where I am . Is there any way I can get the local time at the location where the user is actually located. ?

View Replies View Related

How To Get Asp Execution Time And Database Connection Time ?

Any some tools or sample codes drop down asp script execute time and
database connection time ?

View Replies View Related

Server Time Local Time Convert

I'm trying to do a very simple code that converts the server time into a time zone of your choice.

<%
dim h 'Current Hour
dim i ' Time Zone Increase - add or subtract hours
dim r 'Result Here
h = Hour(Now)
i = + 2
r = h + i
%>

but obvisouly i'm having trouble with the time zone convert.

View Replies View Related

Compare The NOW Time With A Deadline Time

I am trying to compare the NOW time with a "deadline" time. Please help. Just not sure why this is not working. I need to be able to say IF IT'S BEFORE 9:30 TODAY, IT'S OKAY TO ADD SOMETHING. IF IT'S AFTER 9:30 TODAY, YOU MUST ADD IT TOMORROW.

CODE:

nowtime=now()
deadlinetime=formatdatetime(now(),2) + " 8:30:00 AM"
response.write "NOW: " & nowtime & "<BR>"
response.write "Deadline: " & deadlinetime & "<BR>"
if nowtime<deadlinetime then response.write "can send out today" end if
if nowtime>deadlinetime then response.write "must send out tomorrow" end
if

RESULTS:
NOW: 1/18/2007 8:51:43 AM
Deadline: 1/18/2007 8:30:00 AM
can send out today

As you can see, NOW is GREATER THAN Deadline, so it should must send out tomorrow.

View Replies View Related

Time Calculation :: Between Two Dates And Time

i want to calculate the total time between to dates and time.

Example: Total time elapsed from date 1 time 1 to date 2 time 2.

27/09/2004 11:00 - 28/09/2004 10:30

The user enters a record and then later comes back and closes it. I need to know the time it took from when they entered the record until the time it was closed.

View Replies View Related

Time

i am trying to get a time variable which is 30 minutes before the current time to use in a calculation.
The code I am using is:

validationtime=time-3000
response.write(time)
response.write ("<BR>")
response.write(validationtime)

but the response I get is incorrect along the lines of:
11:54:42
14/10/1891 12:05:18

What am I doing wrong, why is validation time also including a date

View Replies View Related

Time

Can someone tell me how i can use a if loop

its related with time I want to display a registration form on 29 Jan 2007

only between 10am pacific time to 1pm pacific time

so only between 10am - 1pm pacific time the registration form should appear

i live in the central time zone

can someone tell me how i can make this happen.

View Replies View Related

Using Time

I am trying to use the time function to determine whether or not it is morning, afternoon or evening.

I wrote my code and then changed the values it is comparing with to see if would work and it doesn't, it just stays on the good morning.

<% if time > 0 then %>
Good Morning <b><%= Session("sessFirstName") %></b><br><br>
<a href="logout.asp">Log Out</a>
<% end if %>

<% if time > 12 then %>
Good Afternoon <b><%= Session("sessFirstName") %></b><br><br>
<a href="logout.asp">Log Out</a>
<% end if %>

<% if time > 18 then %>
Good Evening <b><%= Session("sessFirstName") %></b><br><br>
<a href="logout.asp">Log Out</a>
<% end if %>

Do i need to put quotes around the number i am checking with?

View Replies View Related

Time

how can i get this tag to adjust for time zones? This is probably simple, but i just can't think of how to do it. Code: <%=Time%>

View Replies View Related

Time Out

I am writing an XML file with lots of Data and it takes time but before the operation can be finished I get this error

Quote:

The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.

How do I handle this?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved