Re: [WebDNA] Converting minutes to hours
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101182
interpreted = N
texte = --Apple-Mail-140-985085637Content-Type: text/plain;charset=US-ASCII;format=flowed;delsp=yesContent-Transfer-Encoding: 7bitThe database actually houses time worked as a function of time (i.e. 03:30:00 hours worked). The hours and minutes are then pulled separately from the database using a [GetChars]. If there was some way to multiply time by an integer to get an integer, that would solve my problem. But I don't see that feature in the docs.On Oct 15, 2008, at 4:07 PM, Gary Krockover wrote:> Does your database store a bunch of entries such as:>> HOUR MINUTES> 1 30> 0 45> 2 15>> ?>> GJK>> At 02:24 PM 10/15/2008, you wrote:>> I'm trying to convert minutes to hours to simplify a payroll process.>> My minutes are tallied in either 15, 30 or 45 minute increments. In>> order to add the hours and minutes together properly, I need to >> figure>> out a way to convert the minutes to part of an hour and then multiple>> by the pay rate. Does anyone know how to do this using WebDNA >> version>> 3.0?>>>> Here's a code snippet...>>>> Total Time worked: [HoursTotal] hrs and [MinutesTotal] minutes >>
>> Total Cost: $[math][HoursTotal]*[lookup>> db=my.db&value=[Employee]&lookInField= Employee&returnField=>> Employee_Rate¬Found=][/math]
>>>> Thanks!>> Suzanne--Apple-Mail-140-985085637Content-Type: text/html;charset=US-ASCIIContent-Transfer-Encoding: quoted-printableThe database actually houses =time worked as a function of time (i.e. 03:30:00 hours worked). = The hours and minutes are then pulled separately from the database =using a [GetChars]. If there was some way to multiply time by an =integer to get an integer, that would solve my problem. But I =don't see that feature in the docs.
On Oct 15, =2008, at 4:07 PM, Gary Krockover wrote:
=
Does your database store a bunch of entries such =as:
HOUR MINUTES
=1 30
=0 45
=2 15
=?
GJK
At 02:24 PM 10/15/2008, you wrote:
=I'm trying to convert minutes to hours to simplify a payroll =process.
My minutes are tallied in either 15, 30 or 45 =minute increments. In
order to add the hours and =minutes together properly, I need to figure
out a way to =convert the minutes to part of an hour and then multiple
by =the pay rate. Does anyone know how to do this using WebDNA =version
3.0?
Here's a code snippet...
Total =Time worked: [HoursTotal] hrs and [MinutesTotal] minutes =<br><br>
Total Cost: $[math][HoursTotal]*[lookup =
db=3Dmy.db&value=3D[Employee]&lookInField=3D =Employee&returnField=3D
=Employee_Rate¬Found=3D][/math]<br></font>
=Thanks!
Suzanne
=
=--Apple-Mail-140-985085637--
Associated Messages, from the most recent to the oldest:
--Apple-Mail-140-985085637Content-Type: text/plain;charset=US-ASCII;format=flowed;delsp=yesContent-Transfer-Encoding: 7bitThe database actually houses time worked as a function of time (i.e. 03:30:00 hours worked). The hours and minutes are then pulled separately from the database using a
[getchars]. If there was some way to multiply time by an integer to get an integer, that would solve my problem. But I don't see that feature in the docs.On Oct 15, 2008, at 4:07 PM, Gary Krockover wrote:> Does your database store a bunch of entries such as:>> HOUR MINUTES> 1 30> 0 45> 2 15>> ?>> GJK>> At 02:24 PM 10/15/2008, you wrote:>> I'm trying to convert minutes to hours to simplify a payroll process.>> My minutes are tallied in either 15, 30 or 45 minute increments. In>> order to add the hours and minutes together properly, I need to >> figure>> out a way to convert the minutes to part of an hour and then multiple>> by the pay rate. Does anyone know how to do this using WebDNA >> version>> 3.0?>>>> Here's a code snippet...>>>> Total Time worked: [HoursTotal] hrs and [MinutesTotal] minutes >>
>> Total Cost: $
[math][HoursTotal]*[lookup>> db=my.db&value=[Employee]&lookInField= Employee&returnField=>> Employee_Rate¬Found=][/math]
>>>> Thanks!>> Suzanne--Apple-Mail-140-985085637Content-Type: text/html;charset=US-ASCIIContent-Transfer-Encoding: quoted-printableThe database actually houses =time worked as a function of time (i.e. 03:30:00 hours worked). = The hours and minutes are then pulled separately from the database =using a
[getchars]. If there was some way to multiply time by an =integer to get an integer, that would solve my problem. But I =don't see that feature in the docs.
On Oct 15, =2008, at 4:07 PM, Gary Krockover wrote:
=
Does your database store a bunch of entries such =as:
HOUR MINUTES
=1 30
=0 45
=2 15
=?
GJK
At 02:24 PM 10/15/2008, you wrote:
=I'm trying to convert minutes to hours to simplify a payroll =process.
My minutes are tallied in either 15, 30 or 45 =minute increments. In
order to add the hours and =minutes together properly, I need to figure
out a way to =convert the minutes to part of an hour and then multiple
by =the pay rate. Does anyone know how to do this using WebDNA =version
3.0?
Here's a code snippet...
Total =Time worked: [HoursTotal] hrs and [MinutesTotal] minutes =<br><br>
Total Cost: $[math][HoursTotal]*[lookup =
db=3Dmy.db&value=3D[Employee]&lookInField=3D =Employee&returnField=3D
=Employee_Rate¬Found=3D][/math]<br></font>
=Thanks!
Suzanne
=
=--Apple-Mail-140-985085637--
Suzanne Swift
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Date search - yes or no (1997)
Security Question (1997)
tracking variables across a site... (2000)
Automatic thumbnail images (1998)
Help! (2000)
Question (1997)
Change Subtotal (2000)
Bug or syntax error on my part? (1997)
Upgrading old WebCat Database Files (1997)
autosensing lanague selection (1997)
Separate SSL Server (1997)
how to post without certain data appearing in the html source (2001)
How to append text after the sign & (1997)
HELP WITH DATES (1997)
[WebDNA] Just drop the Server version (2015)
ShipTotal Again (1998)
can WC render sites out? (1997)
Keeping text formatting (like hard returns) (2002)
WebCat editing, SiteGuard & SiteEdit (1997)
Searching multiple Databases (1997)