BOBSCOTT wrote on Nov 14^th, 2011 at 9:21pm:


Probably.

When doing math on any commodity in which it is being measured by different whole units that comprise one-another, to convert it all to the smallest single unit that you care about.

Wow Ray,

Looking at your code I guess I was really  going down a scary path.  See Below.

I know it was not clean and I needed to do things like initialize var at the start but I was just trying to "logically" walk down the path of what I needed, so I laid the Sbasic out just like the steps I "Thought" I needed to follow.

I was still struggling at the end to build my seconds back up to time but It sure is extremely convoluted compared to yours.

It proves desire is no match for intelligence! Thanks for sharing a little smarts with me. I always appreciate it.

I am going to play with your code, what format does date in and out and time in and out need to be in?

Thanks again,
Robert


var vgotHour as int
var VgotMins as int
var vgotSecs as int
var vgotAMPM as String

var vgotHourTotSec as int
var VgotMinsTotSec as int
var VgotTotalSec as int

var vHour as int
var VMins as int
var vSecs as int
Var VtotalNow as Int

var vYear as String
var vMnth as String
var vDom as String

var vdayspast as int
var vdayspastsec as int

var vFinsec as int
var vTimeGood as int

// This section figures seconds so far today as of this moment

SetStringArraySeparator(":")

//converts hours to seconds
vHour = @AccessStringArray(@ServerTime(), 1)
vhour = @tonumber(vhour) * 3600
//vhour = @tonumber(vhour) * 60

//converts minutes to seconds
vMins = @AccessStringArray(@ServerTime(), 2)
vMins = @tonumber(Vmins) * 60

//seconds from now time
vSecs = @AccessStringArray(@ServerTime(), 3)

// Total of seconds of today
VtotalNow = Vhour + Vmins + Vsecs

RestoreStringArraySeparator()



// This section figures seconds so total from file we want to calculate how long its been since it was created

// calculates how many if any days have passed

If not @isblank(scriptgotdate)

Then
{
           if @date <> scriptgotdate

     {
vdayspast = ( @TN(@Date - @D(scriptgotdate)) )

//writeln("days past total " + vdayspast)

//subtracks 1 day from total days if its greater than 0 so we can calculate from time recieved till end of the day seconds
     //If vdayspast > 0

      vdayspast = ( vdayspast - 1 )
     //writeln("days past total minus 1 " + vdayspast)
     }

}

// multiplies full days by 86400 (total seconds in day)
vdayspastsec = vdayspast * 86400

// calculates from file created time till midnight

// finds am or pm
vgotAMPM = @Right(scriptgottime,2)

// finds hour
vgotHour = @LEFT(scriptgottime,2)
//vhour = @tonumber(vhour) * 3600
//vhour = @tonumber(vhour) * 60

//converts minutes to seconds
vgotMins = @MID(scriptgottime, 4, 2)
//vMins = @tonumber(Vmins) * 60

// calculates hours seconds based on AM or PM

If      VgotAMPM = "AM"

Then
     {

           vgotHourTotSec      = @tonumber(vgothour) * 3600
     }
Else
     {
           VgotHour = VgotHour + 12
           vgotHourTotSec      = @tonumber(vgothour) * 3600
     }

// calculates min seconds

VgotMinsTotSec = @tonumber(Vgotmins) * 60

//Totals Got Seconds

VgotTotalSec = VgotHourTotSec + VgotMinsTotSec

//writeln("got hour  "+ vgothour)
//writeln("got min  "+ Vgotmins)
//writeln("got am or pm  "+ VgotAMPM)

//writeln(vhour)
//writeln(Vmins)
//writeln(Vsecs)
//writeln("Total second now " + Vtotalnow)

writeln(vgotHourTotSec)
writeln(VgotMinsTotSec)
writeln("Total second got " + VgotTotalSec)

// subtract now sec from got sec leaving total seconds since file created
vFinsec = VgotTotalSec - Vtotalnow

writeln("Total second since file created " + vFinsec)

// turn total sec into actual time since file created

// turn into minites
vTimeGood = vfinsec / 60


// turn into Hours
vTimeGood = vfinsec / 60


writeln("Total hours since file created " + vTimeGood)

Ray,

It works like a charm!!!!!!!!!!

Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You So Much.