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:
Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997)
[WebDNA] [BULK] which of these tags exist in 7.0 (2011)
DataBaseHelper Flawed (1997)
[TaxableTotal] - not working with AOL and IE (1997)
Another Search Question (2003)
Help with Repost Data msg from form (1997)
Need Sample Template - just purchased (1997)
WebCat2 - [format thousands] (1997)
Founditems (1998)
trouble updating records in database (1998)
WARNING: MacOS The installer is broken... (2000)
[ShowIf] and empty fields (1997)
possible bug in unix version? (2000)
WebCat Code and WebStar Search? (2000)
Protect (1997)
Security for malls with different webmasters (1998)
Purchased cart being overwritten - still !?? (1997)
Shopping cart problem (2003)
createfolder not behaving as expected (1999)
WC --> printer (1998)