JavaScript - Calculating The Difference Between Two Dates

Hello everyone. Below is code I have developed for a simple spreadsheet. The issue I am having is that when I total a row or column using "=sum(a1:a5)" and then I try and total another row and add the sum of the two totals together I am not getting a valid response back. All I am presented with is a "0" in the column cell. Here is the code in two files and have also included an attachment of the whole project:

tablepage.js
Code:

// JavaScript Document

var tblRows = 20;
var tblColumns = 10;
var tblArray = new Array(tblRows);
var p = window.parent;

// Initial page event handler
function initPage() 
{
    p.refAssignCellFromTextbox = assignCellFromTextbox;

    for (var i = 0; i < tblArray.length; i++) 
	{
        tblArray[i] = new Array(tblColumns);
        for (var j = 0; j < tblArray[i].length; j++)
            tblArray[i][j] = "0";
    }

    recalculate();
}

// Recalculate cell values
function recalculate() 
{
    for (var i = 0; i < tblRows; i++) 
	{
        for (var j = 0; j < tblColumns; j++) 
		{
            if (tblArray[i][j].indexOf("=SUM") != -1) 
			{
                calculateCell(i, j);            
            }
        }
    }
}

// Click cell event handler
function clickCell(cellRef) 
{
    thisRef = cellRef;
	
    var cellID = cellRef.id;

    var row = parseFloat(cellID.substr(0, 3)) - 1;
    var column = parseFloat(cellID.substr(3, 2)) - 1;

    var cellValue = tblArray[row][column];
    var tokenArray = getFormula(cellValue);

    if (tokenArray != null)
        p.assignTextboxFromArray(cellValue);
    else
        p.assignTextboxFromCell(cellRef);
}

// Update cell from textbox
function assignCellFromTextbox(tblValue) 
{
    if (thisRef != undefined) 
	{
        if (tblValue == "") 
		{
            tblValue = "0";
        }
        var tokenArray = getFormula(tblValue);

        if (tokenArray != null) 
		{
            assignArray(thisRef.id, tblValue.toUpperCase());
        }
        else 
		{
            if (!isFloat(tblValue)) 
			{
                    parseValue = tblValue.replace(/[^0-9]/g, '');
                    tblValue = parseValue;
            }
            assignArray(thisRef.id, tblValue);
            if (tblValue == "0")
                thisRef.innerText = "";
            else
                thisRef.innerText = tblValue;
        }
		
        recalculate();
    }
}

// Determines if a user entered a formula
function getFormula(tblValue) 
{
    var pattern = /[:|\(|\)]/;
    var ar = tblValue.split(pattern);
    var sum = ar[0].toUpperCase();

    if (ar.length < 3)
        return null;
    else if (sum != "=SUM") 
	{
        return null;
    }
    else 
	{
        return ar;
    }
}

function assignArray(cellID, tblValue) 
{
    var row = parseFloat(cellID.substr(0, 3));
    var column = parseFloat(cellID.substr(3, 2));

    tblArray[row - 1][column - 1] = tblValue;
}

function calculateCell(row, column)
{
    var tokenArray = getFormula(tblArray[row][column]);

    if (tokenArray != null) 
	{
        var fromColumn = tokenArray[1].substr(0, 1);
        var fromRow = tokenArray[1].substr(1, tokenArray[1].length - 1);

        var toColumn = tokenArray[2].substr(0, 1);
        var toRow = tokenArray[2].substr(1, tokenArray[2].length - 1);

        var fromRowIndex = parseFloat(fromRow) - 1;
        var fromColIndex = fromColumn.charCodeAt(0) - 65;

        var toRowIndex = parseFloat(toRow) - 1;
        var toColIndex = toColumn.charCodeAt(0) - 65;

        var sumTotal = 0;

        for (var i = fromRowIndex; i <= toRowIndex; i++) 
		{
            for (var j = fromColIndex; j <= toColIndex; j++) 
			{
                if (isFloat(tblArray[i][j]))
                    sumTotal += parseFloat(tblArray[i][j]);
            }
        }

        var cellID = fillField((row + 1).toString(), 3) + fillField((column + 1).toString(), 2);
        document.getElementById(cellID).innerText = sumTotal;
    }
}

function isFloat(s) 
{
    var ch = "";
    var justFloat = "0123456789.";

    for (var i = 0; i < s.length; i++) 
	{
        ch = s.substr(i, 1);
        if (justFloat.indexOf(ch) == -1)
            return false;
    }
    return true;
}

function fillField(s,n)
{
    var zeros = "0000000000";
    return zeros.substring(0, n - s.length) + s;
}

spreadsheet.js
Code:

// JavaScript Document

var refAssignCellFromTextbox;
var nCharsAllowed = "ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890.=(): ";


// Event Handler
function initPage() 
{
    document.getElementById("TableFrame").style.top = "50px";
    document.getElementById("TableFrame").src = "tablepage.html";
}

// Updates text field when a user clicks on a particular field from with the spreadsheet
function assignTextboxFromCell(cValue) 
{
    document.getElementById("fieldEntry").value = cValue.innerText;
    document.getElementById("fieldEntry").focus();
}

// Assists tablepage.js with updating a value from a 2D array
function assignTextboxFromArray(aValue) 
{
    document.getElementById("fieldEntry").value = aValue;
    document.getElementById("fieldEntry").focus();
}

// Used when a user presses a key to update text field
function filterText() 
{
    if (window.event.keyCode != 13) 
	{
        if (!nCharOK(window.event.keyCode))
            window.event.keyCode = null;
    }
    else 
	{
        window.event.keyCode = null;
        refAssignCellFromTextbox(document.getElementById("fieldEntry").value);
    }
}

// Checks to see if character entered falls within our preset
function nCharOK(c) 
{
    var ch = (String.fromCharCode(c));
    ch = ch.toUpperCase();

    if (nCharsAllowed.indexOf(ch) != -1)
        return true;
    else
        return false;
}

// Clears all data from the screen
function clearPage() 
{
    initPage();
    document.getElementById("fieldEntry").value = "";
}

// Add a row to the table
function addRow(frmTable) 
{
	var table = document.getElementById(frmTable);
	var rowCount = table.rows.length;
	var row = table.insertRow(rowCount);
	var cell1 = row.insertCell(0);
	// cell2.innerHTML = rowCount + 1;
	// Unless this is going to be completely dynamic
	// the rest of the table code would have had to be 
	// entered in statically. Not happening.
}

// Delete a row from the table
function deleteRow(frmTable) 
{
	try 
	{
		var table = document.getElementById(frmTable);
		var rowCount = table.rows.length;

		for(var i=0; i<rowCount; i++) 
		{
			var row = table.rows[i];
			var chkbox = row.cells[0].childNodes[0];
			if(null != chkbox && true == chkbox.checked) 
			{
				table.deleteRow(i);
				rowCount--;
				i--;
			}
		}
	}
	catch(e) 
	{
		alert(e);
	}
}

to be honest I have no idea where to start, i have a table, with 2 numeric values at the minute, if the checkbox is selected I want the total price to be shown?

Any help to get me started would be great!

this is the form I have with the numeric values

Code:

<form id="calculation" action="#" method="post">

100 <input type="checkbox" name="check1" value="100" onClick='total_cost()'/>

120 <input type="checkbox" name="check2" value="200" onClick='total_cost()'/>

Total cost<input type="text" name="total" id="total" readonly="readonly" />

onClick='total_cost()' is referring to the javascript function where I just don't know where to start?

Hi,

There are two text boxes in a HTML form. The first text box takes the time when the user starts to work on a project. The second box takes the time when the user stops working on that project.

Now, I would like to calculate the total time worked on that project for that user. That is (stop time - start time). I tried few things without success.

Any help will be appreciated.

Hi!
I'm very new to javascript and a bit stuck with trying to calculate values from functions together.
Let's say I have three functions. Each function is given a value and the goal is to calculate all the values together in a variable. This is what I have so far:
Code:

function numberAdd1 () {
addValue = 1;
return.addValue;
}
function numberAdd2 () {
addValue = 2;
return.addValue;
}
function numberAdd3 () {
addValue = 3;
return.addValue;
}

How would I now calculate the return value of each funtion together and store the result in a variable?

I thought this would be simple. Evidently it's not

With the date below (and it being 11.45 on the 27th as I type this), the counter returns the correct number of hours/mins/seconds remaining, but shows 33 days.

It seems to be adding 31 days to the count, but I can't figure out where

Code:

function countdown(){
	
	var bigday	= new Date(2009,10,29,14,30,0,0);
	var today	= new Date();
	
	var difference = bigday - today;
	
	var remaining = Math.floor(difference/1000);	// want seconds, not milliseconds
	
	var days = Math.floor(remaining/86400);
	remaining = remaining % 86400;
	
	var hours = Math.floor(remaining/3600);
	remaining = remaining % 3600;
	
	var minutes = Math.floor(remaining/60);
	remaining = remaining % 60;
	
	seconds = Math.floor(remaining);
	var out = days + " days, " + hours + " hours, " + minutes + " minutes and " + seconds + " seconds left...";
	
	$('#countdown').text(out);
	
	setTimeout(countdown, 1000);
}

I am having difficulty getting the following assignment to run properly:

Many companies charge a shipping and handling charge for purchases. Create a Web page that allows a user to enter a purchase price into a text box and includes a JavaScript function that calculates shipping and handling. Add functionality to the script that adds a minimum shipping and handling charge of $1.50 for any purchase that is less than or equal to $25.00. For any orders over $25.00, add 10% to the total purchase price for shipping and handling, but do not include the $1.50 minmum shipping and handling charge. The formula for calculating a percentage is price * percent / 100. For example, the formula for calculating 10% of a $50.00 purchase price is 50 * 10 / 100, which results in a shipping and handling charge of $5.00. After you determine the total cost of the order (purchase plus shipping and handling), display it in an alert dialog box. Save the document as CalcShipping.html.

This is what I have after working on it round and round for 4 hours yesterday:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Calculate Order</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" href="js_styles.css" type="text/css" />

<script type="text/javascript">
/* <![CDATA[ */

function applyShipping(shipping) {
if (purchase > 25.00)
shipping = purchase * 10 / 100;
}

/* ]]> */
</script>
</head>

<body>

<script type="text/javascript">
/* ![CDATA[ */
document.write("<h1>Purchase Plus Shipping</h1>");
/* ]]> */
</script>

<script type="text/javascript">
/* <![CDATA[ */

var purchase=window.prompt("Please Enter Your purchase amount");
var shipping = 1.50;
applyShipping();
document.write ("<p>The price entered was $" + (purchase) + "</p>");
document.write ("<p>Shipping and Handling $" + (shipping) + "</p>");

var totalPrice = purchase + shipping;
document.write ("<p>Your total price is $" + (totalPrice) + "</p>");
// window.alert("Your total price is $" + (totalPrice) + );//

/* ]]> */
</script>
</body>
</html>

Hi guys
Sorry about the vague Title, but I really do not know anything about JavaScript. Infact I only know very VERY basic html... So I hope you can help me.

I am trying to create a form like this:


Where the blue is user entered, and red is results.

Apparently I can't do that with my basic html skills but javascript can?

The Formula via excel for 'Generic SOP' is
=100-((ABS(A3-10))+(ABS(B3-10))+(ABS(C3-10))+(ABS(D3-10))+(ABS(E3-10))+(ABS(A6-10))+(ABS(B6-10))+(ABS(C6-10))+(ABS((D6-20)/2))+(ABS(E6-10)))

and for 'SOP'
=100-((ABS(A3-10)*1.5)+(ABS(B3-10)*1)+(ABS(C3-10)*1)+(ABS(D3-10)*2)+(ABS(E3-10)*1)+(ABS(A6-10)*0.5)+(ABS(B6-10)*0.5)+(ABS(C6-10)*1)+(ABS(D6-20)/2)+(ABS(E6-10)*0.5))

I would also like a drop down box that allows me to choose different variables that changes the 'SOP' formula slightly.. but maybe I should leave that out for now..

I hope that was understandable and if this is too much to ask just tell me to get nicked and go learn how to code myself..

Thankyou for looking guys

Hey there, first time poster. I am trying to create an order with the ability to dynamically self total the sum of the selected items but also be able to add a 25% labor fee having it be at least $90.

So if someone buys $300 worth of items the labor charge would be $75 but it would be automatically bumped to $90.

heres the existing code:

PHP Code:
* Calculates the payment total with quantites
     * @param {Object} prices
     */
    countTotal: function(prices){
    
        var total = 0;
        $H(prices).each(function(pair){
            total = parseFloat(total);
            var price = parseFloat(pair.value.price);
            if ($(pair.key).checked) {
                if ($(pair.value.quantityField)) {
                    price = price * parseInt($(pair.value.quantityField).getSelected().text, 10);
                }
                total += price;
            }
        });
        
        if (total === 0) {
            total = "0.00";
        }
        if ($("payment_total")) {
            $("payment_total").update(parseFloat(total).toFixed(2));
        }
    },
    /**
     * Sets the events for dynamic total calculation
     * @param {Object} prices
     */
    totalCounter: function(prices){
        $H(prices).each(function(pair){
            $(pair.key).observe('click', function(){
                JotForm.countTotal(prices);
            });
            if ($(pair.value.quantityField)) {
                $(pair.value.quantityField).observe('change', function(){
                    $(pair.key).checked = true;
                    JotForm.countTotal(prices);
                });
            }
        });
    }, 

I'm trying to find the difference between 2 times. Time formats are 00:00:00.0

For example...
var t1 = "00:07:51.0";
var t2 = "00:53:21.0";

How do I calculate the difference between those 2 times?

TIA.

Can someone please assist. I am trying to create a order form that auto calculates my totals as I enter the quantities. It comes up with Not a Number(NaN).

Below are snippets from my code this is obviously in a <form>:

HTML:
Code:

<!-- Row 3, Col 3 purchase boxes -->
<td colspan="1" height="120" align="left">
<input style="margin-left: 60px" type="text" name="bed_359" size="3" maxlength="3" onchange="calculateValue(this.form)" /> R359</td></tr>

<!-- Row 10, Col 2 Order Value Box-->
<td colspan="1" align="left"><input style="margin-left: 60px" type="text" name="total" size="10" 
onfocus="this.form.elements[0].focus()" />
</td></tr>

javaScript:
Code:

// Function to calculate order value	
function calculateValue(orders) {
	var orderValue = 0;
	var value = 0;
	var itemPrice = 0;
	var itemQuantity = 0;
	
	// Run through all the product fields
	for(var i = 0; i < orders.elements.length; ++i) {
	
	// Get the current field
	formField = orders.elements[i];
	
	// Get the fields name
	formName = formField.name;
	
	// Items price extracted from name
	itemPrice = parseFloat(formName.substring(formName.lastIndexOf("0") + 1));
	
	// Get the Quantity
	itemQuantity = parseInt(formField.value);
	
	// Update the OrderValue
	if(itemQuantity >= 0) {
	value = itemQuantity * itemPrice;
	orderValue += value;
	}
	}
	
	// Display the total
    orders.total.value = orderValue;
}

Please help its probably something simple.

Folks,

I am trying to calculate the total of fields on a web form.
I have multiple rows of 10 fields with a total for each.
Each row comes from a different record in a database.
I am only showing 2 fields of the 10 for simplicity.

The name and id of each field looks like
"Q300_1" onchange="update(Q300)"
"Q300_2" onchange="update(Q300)"
"Q300_t"
"Q301_1" onchange="update(Q301)"
"Q301_2" onchange="update(Q301)"
"Q301_t"


My current attempt at the script looks like:
[CODE]
<script type="text/javascript">
function update(item) {
var itemt=item + "_t";
var item1=item + "_1";
var item2=item + "_2";
document.myform[itemt].value = (document.myform[item1].value -0) + (document.myform[item2].value -0);
}
</script>
[CODE]

It does not work and I get
Error: Q301 is not defined
in the Firefox error console.

hey guys, happy new year! , I was wondering how to calculate an outcome/number through a combination of 4 drop down menus (drop down menu's 1 and 2 combine to form a specific value and menu's 3 and 4 combine to form a specific value), example ;
1st drop down menu (1*) = a,b,c,d,e
2nd drop down menu (2*) = 5,4,3,2,1
3rd drop down menu (3*)= a,b,c,d,e
4th drop down menu (4*)= 5,4,3,2,1

Example of drop down menu layout - View image: example

a->e = low to high (value) predominant value so b5>a1 ; d5>c1
5->1 = low to high (value)

Then the calculation involves the 1st and 2nd menu to form 1 value, so c3, e4 etc and the 3rd and 4th menu unite to form 1 value that is different from the first; c2, e3
So (1*2*) b3 ; (3*4*) b1 = x value
Also the value from 1*2* menu must be lower than value from menu 3*4*; so you cannot input 1*2* c4 ; 3*4* c5 /or b1 (so once the first menu is selected, the 3rd and 4th menu's wont show anything lower)

I am not sure the best way about going to calculate the value for x (generated from the menu combinations) however I can outline the values for each combination as it involves simple addition;
Example; 1*2* c5 ; 3*4* c4 = 39
Example; 1*2* c4 ; 3*4* c3 = 43
Example; 1*2* c3 ; 3*4* c2 = 44
Example; 1*2* c2 ; 3*4* c1 = 49
Therefore 1*2* c5 ; 3*4* c1 = 175 (c5>c4 + c4>c3 + c3>c2 + c2>c1 = 175)
Starting from a5 to e1 the values are as follows; [(a5->a4 = 17),17,17,17],[(a1->b5 = 22.5),22.5,22.5,22.5],[39.6,39.6,43,44],[49,56.7,56.7,60],[69,76.5,90,161],[189.5,216,(e2->e1 = 246.5),no further value (no f5)]

If you could help me out that would be amazing, appreciate any help/feedback in advance!

Hi all,
I am trying to have a form calculate total using this script, works OK until the total reaches 99 from there on it only returns 2 figures. Also it won't work if I complete the dollar value (i.e add .00)
Anyone tell me where I am going wrong?

Code:

<script type="text/javascript">
		function startCalc(){
  		interval = setInterval("calc()",1);
		}
		function calc(){
		q1 = document.apply.appfee.value = 11;
		q2 = document.apply.memfee.value = 20;
		q3 = document.apply.levy.value;
		q4 = document.apply.donation.value;
		document.apply.total.value = (q1*1) + (q2*1) + (q3*1) + (q4*1)
		}
		function stopCalc(){
  		clearInterval(interval);
		}
		</script>

This is the form:
Code:

<form name="apply" action="" method="post" onsubmit="return validate(apply)">
<table style="width:680px;">
			<tr>
				<td style="text-align:right; white-space:nowrap; width:300px;">Application Fee:</td>
				<td style="text-align:left; white-space:nowrap; width:441px">$<input type="text" readonly value="" name="appfee" style="width:17px; border:0; font:11px verdana; color:#006;margin-bottom:5px;"></td>
			</tr>
			<tr>
				<td style="text-align:right; white-space:nowrap; width:300px;">Annual Memebership Fee:</td>
				<td style="text-align:left; white-space:nowrap;">$<input type="text" readonly value="" name="memfee" style="width:17px; border:0; font:11px verdana; color:#006;margin-bottom:5px;"></td>
			</tr>
			<tr>
				<td style="text-align:right; white-space:nowrap; width:300px;">* Optional Annual Levy:</td>
				<td style="text-align:left;">
					$<select name="levy" onFocus="startCalc();" onBlur="stopCalc();">
					<option selected>0</option>
					<option value="22">22</option>
					<option value="44">44</option>
					<option value="66">66</option>
					<option value="88">88</option>
					<option value="110.00">110</option>
					</select>
				</td>
			</tr>
			<tr>
				<td style="text-align:right; white-space:nowrap; width:300px;">* Optional Donation:</td>
				<td>$<input type="text" name="donation" value="" onFocus="startCalc();" onBlur="stopCalc();" style="font:11px verdana; color:#006;margin-bottom:5px; width:80px;"></td>
			</tr>
			<tr>
				<td style="text-align:right; white-space:nowrap; width:300px;"><b>TOTAL:</b></td>
				<td white-space:nowrap;><b>$<input type="text" name="total" style="width:17px; border:0; font:bold 11px verdana; color:#006;margin-bottom:6px;"></b></td>
			</tr>
		</table>
</form>

Hi ,

I am using date of birth field in my application and i m taking date of birth in yyyy-mm-dd format.

I need to calculate age by using this date of birth and should show alert if age is less than 5 years.

help me....

Thanks in advance