Converting Seconds To Minutes

I have a column in my Access db that stores a number which is supposed to be seconds. How can I convert the seconds to display mm:ss on my ASP page? For instance, if the number in the db is 300, I want it to display 5:00 on my page.

Now these are lengths of time, not current time (AM or PM), so I dont want it to display the AM or PM. I've tried format(rs("length"), "nn:ss") and that didnt work. Matter of fact Format(), FormatDateTime(), and FormatNumber() doesnt work on my page. I've been getting the 800a000d Type Mismatch error. What am I doing wrong? Code:

View Replies


ADVERTISEMENT

Converting Seconds Into Time

I need to convert seconds into time since for a message board application.

"minutes ago, hours ago and days ago" etc.

I have capture the time of the original post and compared it to the time now getting seconds but having a little trouble working out the seconds into time. Have used calculations (/60 minute), (/3600 hour), and (/86400 hour) but the time remaining is bugging me.

View Replies View Related

Existing Minutes

is it possible to add a number in time? i created a code which is something like this

x=date
y=x+2
response.write(y)

but it doesnt work... for example the time is 08:32:05 AM and im going to add 2 minutes the result should be 08:34:05

View Replies View Related

Now() Minus 20 Minutes?

I wish to count the lastLoginDateTime field that has any date and time in it that is within 20 minutes of now(). Code:

View Replies View Related

Minutes Tracker

Has anyone come across a system for tracking meeting minutes written in ASP? I have searched quite a bit on the web and I haven't come up with much. It looks like I will have to write my own unless someone has any ideas.

View Replies View Related

Calculating Minutes Between Dates

I need to calculate the number of elapsed minutes between two datetime variables. BUT, it needs to only include times between 8am and 5pm on weekdays.

So if the starting datetime is at 5:01pm, it doesn't start counting until 8am the next weekday morning.

Or, if the ending datetime is at 6:30am, the counting would stop at 5pm the previous weekday.

View Replies View Related

Session Timeout 60 Minutes

I am trying to make an access control where a code should be available for 60 minutes. When my user is login on I am doing this, after his access code has been authorized:

Session.Timeout=70
Session("Time")= Dateadd("n","65",now())
And in the pages where is allowed (for one hour) I am doing this:

if cdate(Session("Time")) < cdate(now()) then
Session.Abandon
end if

Does it look correct or is there a better way of doing this?

View Replies View Related

Falsh Text If Time NOW() IS < 20 MINUTES AWAY

I need to Flash dynamic text on ASP page if the time in the record is less
than 20 minutes from NOW() time.

View Replies View Related

Generate An Application To Check Something Every 20 Minutes

I want to create a 20 minute loop to generate an include file based on the html output of another file on a remote server. Is this possible using ASP? If so, how do you generate an application to check something every 20 minutes?!

View Replies View Related

Timestamp In Seconds ?

i need to get the number of seconds since Jan 1, 1990 or 70 or something to compare session times ... how do i get the timestamp in seconds ...

btw the msdn library is not a very good one ... does any one know an asp manual simillar to php (downloadble) ...

View Replies View Related

Trimming Seconds

Code:

StartTime = FormatDateTime((rs("startdate")),3)

this returns

7/4/2006 1:00:00 AM

I need to trim the seconds off so it looks like this

7/4/2006 1:00 AM

View Replies View Related

Date Difference In Seconds

Basically I have 2 times:

timea = (date here) 12:00:00 PM

timeb = now()

and what i want to do is compare the difference in seconds between the two.
But I'm struggling and the thought has crossed my mind that DateDiff only works with dates not times...

Code:

<%
Dim DateToCompareTo
DateToCompareTo = 4/10/2005 1:00:00 PM
%>

There are <%= DateDiff("s", Now(), DateToCompareTo) %> seconds left %>!

View Replies View Related

Seconds To Date Format

I have a variable that returns a certain number of seconds. Is there a function that can format this into something more useful?

For example, if the variable returned is 32, then it would format it to say "32 seconds"

If the variable is 312, then it would return "5 minutes and 12 seconds"

If the variable was 7315 then it would return "2 hours, 1 minute, and 55 seconds"

And so on.

View Replies View Related

Response.Redirect In 5 Seconds?

Is there a way to response.redirect to a url within 5 seconds or something, so its not right away? I was thinking meta refresh, but everywhere I go online it says that meta refreshes are not a good idea.

View Replies View Related

Seconds Portion Of Time

I'm having a problem with this code:
Code:

<input type="hidden" name="lastdate" value="<%=now%>">

not returning the "seconds" portion of time. It writes the date and time - but only to the minute. The seconds are 00 each time. Ex. 1/29/2005 1:47:23 PM is what I want and 1/29/2005 1:47:00 PM is what I'm getting.This is the result I'm getting on two separate DB's on two different servers. I'm sure there's some glaring problem I'm overlooking because I sure can't see it.

View Replies View Related

Redirect A User After A Few Seconds

I'm trying to set up an asp script that redirects a user after a few seconds on a page- I cant use meta tags to redirect due to the page structure.does anyone have any similar scripts they could share?

View Replies View Related

Delay, Sleep For 8 Seconds

What is the best way to do an ASP/sleep for 8 seconds (pause script for 8 seconds)? I have tried the following:

EndTime = Now() + (8 / (24 * 60* 60)) '8 seconds
Do While Now() < EndTime
'Do nothing
Loop

But unfortunately that keeps the CPU at 100% for that time. I need something that doesn't impact the CPU, as this delay will be in a while loop that will execute continuously for a few days.

View Replies View Related

Time Difference In Seconds

I'd like to find the time difference in seconds in my ASP-code, but can't find how to do this. In php you have the time() that give the seconds from 1.1.1970 (?) until now. Is there something like this in ASP too? I have found the DateDiff that one just gives days, right? I basicly want to have two variables, time1 and time2, and show the seconds between them.

View Replies View Related

Time Format: Get Rid Of Seconds

I have a simple calendar scipt that ask for time of event input. While I like the time feature I do not like the fact that it displays with seconds included.

Ex. Displays HR:MIN:SEC 5:05:30 PM

Desired display 5:05 PM

How do I get rid of the display showing seconds? I have changed the database format, but this does not seem to effect the disply on the asp page.

View Replies View Related

Page Generation Time In Seconds

The code to show how long it took the page to generate in seconds ?!?, if you get onto the main page of this site, www.tgplus.net and loom at the left had side, it tells you how long it took the page 2 generate.

View Replies View Related

Years, Months, Days, Hours, Seconds

Been playing with the function DateDiff, and with it it's easy to calculate the difference in years/months/days between two dates. However, if i wanted to calculate the difference in Years, Months, Days, Hours, Seconds (a la Ebay bids) how can I do this? Is it easy or complicated?

View Replies View Related

Countdown Timer By Day, Hour, Minute And Seconds

how to do the count down timer? which their is count down timer for sepacific day, hour, minute and second.

View Replies View Related

I Am Having Problems With Calculating The Total Seconds From Two Date/times.

I need to get the number of seconds when subtracting two date/times.
With the code I am using below I subtract the two date/times and end
up with a total of days like "1.56".

Then when I multiply it to get
the number of seconds I am not getting an accurate number. I should
only have whole numbers of seconds with nothing past the decimal
point. I would like to be able to subtract the two date/times and get
the number of seconds without multiplying to get it. Is this possible?
Does anyone have a better more accurate way to do this? Code:

View Replies View Related

Converting Hrs And Min To Just Min

I am using two fields on a form to capture time someboby is working. The fields are hours and minutes. How can I when submitting to the db take both fields and convert them to a single field in the db as minutes?

View Replies View Related

Converting PDF To DOC

I'm looking for a control to us on our web site that will take our reports
that are generated in PDF and convert them to DOC format all on the server.
We are using win2k3 web servers if that helps.

View Replies View Related

Converting VBA To ASP

I have developed an access database with VBA. Right now its on a network drive and is shared by 75 users. Works fine.

Now I would like to have this in the company intranet. Is it advisable to go with ASP? I recently installed IIS in my system. After that I have no idea how to convert my application to ? Is there a website or any walk through how to get my stuff's solved.

My application has 20 input screens, data add, save, update and also sends email based on certain rules. Is it possible to do all these stuffs?

View Replies View Related

Converting CSV To XLS In ASP

I want to convert CSV file to XLS. Is there anyway this can be done in ASP without renaming the file to XLS.Also can there Macros to Sort data in it while generating XLS?

View Replies View Related

Converting Cgi To ASP 3

We are evaluating a clients request for converting their existing site using cgi and flat text files to ASP 3 and Access.

The site displays: their products that are broken down into sub categories, guest book, and a survey.

I am only "aware" that text files can be imported into Access but have never done it.

View Replies View Related

Converting PHP To ASP

I have some PHP scripts that need to be converted to ASP3 so that they can run on a Micrsoft NT server using ADO. My knowledge of ASP is limitied so i was hoping you could answer a few questions..

1. Is ADO part of ASP.net or is this completely different?
2. Is ASP3 the same as ASP.net?
3. Is there any advice you can give me regarding converting from PHP to ASP3?

View Replies View Related

Converting

I've stored a set of months in an access database as numbers but when it display on the front end I need it to display as the name of the month.

How would you convert the numbers in the database to their word equivalent? Or is it possible to arrange the months in their correct order in the database?

View Replies View Related

Converting To ASP.net

I have an existing application in asp. I need to add new functionality can I do using ASP.net ?

View Replies View Related

Converting US Time To IST

Do we have any function in ASP that will convert US time(which is captured in the database) to IST

View Replies View Related

Converting Int To Varchar

My data input page uses a id generator which includes dashes, and the
corresponding column in the db is set up as varchar to handle that.
There is a problem, however, when the value in the varchar column is
compared to the string from the URL, and the following error message
occurs:

"Syntax error converting the varchar value '071-213' to a column of
data type int."

<%strSQL = "SELECT * FROM AMS where MinutesID = " & Request ("id")%>

Would it be possible to CAST the request string to varchar?

View Replies View Related







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