Re: [WebDNA] Converting minutes to hours
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101184
interpreted = N
texte = Thank you! I figured I might have to go this route...just thought WebDNA might have a tag that did it for me. Thank you (and everyone else who responded). As a newbie programmer working on "old" code, I appreciate the help! On Oct 15, 2008, at 4:16 PM, Terry Wilson wrote: > Since you are entering either 15, 30, or 45 for the minute portion, > do it like so: > > Total Cost: $[math][HoursTotal] [showif [MinutesTotal]=15].25[/ > showif][showif [MinutesTotal]=30].5[/showif][showif > [MinutesTotal]=45].75[/showif]*[lookup > db=my.db&value=[Employee]&lookInField= Employee&returnField= > Employee_Rate¬Found=][/math] > > Terry > >> 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 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list
. >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ > > -- > Terry Wilson | terry@terryfic.com | http://terryfic.com > http://WhosComing.com - a simplified, affordable online reservation > system > http://TightJacket.com -- stylish protection for your laptop > -------------------------------------------------------------------------- > Attitude is the only difference between ordeal and adventure. > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/
Associated Messages, from the most recent to the oldest:
Thank you! I figured I might have to go this route...just thought WebDNA might have a tag that did it for me. Thank you (and everyone else who responded). As a newbie programmer working on "old" code, I appreciate the help! On Oct 15, 2008, at 4:16 PM, Terry Wilson wrote: > Since you are entering either 15, 30, or 45 for the minute portion, > do it like so: > > Total Cost: $[math][HoursTotal] [showif [MinutesTotal]=15].25[/ > showif][showif [MinutesTotal]=30].5[/showif][showif > [MinutesTotal]=45].75[/showif]*[lookup > db=my.db&value=[Employee]&lookInField= Employee&returnField= > Employee_Rate¬Found=][/math] > > Terry > >> 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 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ > > -- > Terry Wilson | terry@terryfic.com | http://terryfic.com > http://WhosComing.com - a simplified, affordable online reservation > system > http://TightJacket.com -- stylish protection for your laptop > -------------------------------------------------------------------------- > Attitude is the only difference between ordeal and adventure. > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/
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:
multiple db's (2003)
[WebDNA] .htm files (2008)
unable to launch acgi in WebCat (1997)
mass mailing (1998)
[WebDNA] function variables (2011)
WebCat2b13MacPlugIn - More limits on [include] (1997)
HomePage Caution (1997)
Grouping search fields, etc. (1997)
Help formatting search results w/ table (1997)
[lineitems] (2000)
problems with 2 tags shakur (1997)
off topic - dna snipets (1997)
Math problems (1998)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Re:Emailer and encryption (1997)
flushdatabases (1997)
access denied problem (1997)
WebCat2b12--[searchstring] bug (1997)
Another reviewer 'forgets' NT WebCatalog (1998)
Million product store (2003)