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:
.html with IIS4 (1999)
Creating results.... (2003)
Force a search at the default.tmpl page? (1997)
General WebCatalog Questions (1997)
Redirect / errorfiles and netscape (2001)
Emailer 1.0.2 Conflicts? (1998)
WebCat2 several catalogs? (1997)
Location of Browser Info.txt file (1997)
case sensitivity in lookups (1997)
File Upload (1997)
Error Lob.db records error message not name (1997)
Configuration Q (1998)
Limiting user access to .tmpl files (1997)
Order problem (1998)
Archives are missing (2003)
What am I doing wrong? (2000)
Multiple Stores and WebCatalog Prefs (1997)
Separate SSL Server (1997)
Template Cache problem (2000)
Keeping text formatting (like hard returns) (2002)