Re: [WebDNA] Converting minutes to hours
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101186
interpreted = N
texte = Wouldn't it be easier to convert the hours to minutes, add the extra minutes, then multiply by the hourly rate/60? -Jeff On Oct 15, 2008, at 7:57 PM, Terry Wilson wrote: > 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.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:
Wouldn't it be easier to convert the hours to minutes, add the extra minutes, then multiply by the hourly rate/60? -Jeff On Oct 15, 2008, at 7:57 PM, Terry Wilson wrote: > 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.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/
Jeffrey Jones
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:
Two prices in shoppingcart? (1997)
really wierd date stuff on NT (1997)
2nd WebCatalog2 Feature Request (1996)
Auto SKU's (2000)
RE: Suggestions for Topics to be covered in an Advanced WebDNACourse... (1998)
[OT] MacOs IE5 topmargin and leftmargin bug (2000)
Error handling for accountNum (1997)
Hiding HTML and page breaks (1997)
WebCat2: Items xx to xx shown, etc. (1997)
RE: protect tag on NT (1997)
[WebDNA] Installing 6.0 onto Server 2008 (2011)
Help Encrypt/Decrypt eMail (2003)
Error Log.db --however (1997)
[GROUPS] followup (1997)
Cart # Starting at 1000 (2000)
What about this [delete] situation? (1998)
[WebDNA] WebDNA AJAX_Fileuploader (2013)
Quotation Marks in Database (1998)
FAX orders (1996)
Uh...can someone help me out with the b10? (1997)