Re: [WebDNA] Converting minutes to hours
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101185
interpreted = N
texte = Glad to help! Please fix the accidental space that crept in there before the 1st showif though.Terry>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/>>--------------------------------------------------------->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.comhttp://WhosComing.com - a simplified, affordable online reservation systemhttp://TightJacket.com -- stylish protection for your laptop--------------------------------------------------------------------------Attitude is the only difference between ordeal and adventure.
Associated Messages, from the most recent to the oldest:
Glad to help! Please fix the accidental space that crept in there before the 1st showif though.Terry>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/>>--------------------------------------------------------->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.comhttp://WhosComing.com - a simplified, affordable online reservation systemhttp://TightJacket.com -- stylish protection for your laptop--------------------------------------------------------------------------Attitude is the only difference between ordeal and adventure.
Terry Wilson
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:
Smith Micro - no competition (2000)
Yet another db manager (2004)
Appending Record Prob (2001)
Emailer [cart] file names (1997)
Sendmail question [Newbie] (1999)
Funny Math (2000)
Loops and [index] (1998)
Re1000002: Setting up shop (1997)
WebCat2 several catalogs? (1997)
[WebDNA] Server load (2008)
Help with update to 2.11 (1998)
Emailer to include Human Name with email Address (2000)
this works sometimes and sometimes not (1997)
What am I missing (1997)
Setting up a lightbox (2002)
email program problem (1998)
RE: NewCart+Search with one click ? (1997)
Windows 2.1b2 Append Bug? (1997)
Am I going senile? (Price recalc based on quantity) (1997)
Adding a donation amount (2000)