Re: [WebDNA] Converting minutes to hours

This WebDNA talk-list message is from

2008

It keeps the original formatting. numero = 101181
interpreted = N
texte = 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.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:

Re: [WebDNA] Converting minutes to hours (Brian Fries 2008) Re: [WebDNA] Converting minutes to hours (Jeffrey Jones 2008) Re: [WebDNA] Converting minutes to hours (Terry Wilson 2008) Re: [WebDNA] Converting minutes to hours (Suzanne Swift 2008) Re: [WebDNA] Converting minutes to hours (Suzanne Swift 2008) Re: [WebDNA] Converting minutes to hours (Suzanne Swift 2008) Re: [WebDNA] Converting minutes to hours (Terry Wilson 2008) Re: [WebDNA] Converting minutes to hours (Matthew Bohne 2008) Re: [WebDNA] Converting minutes to hours (Gary Krockover 2008) Re: [WebDNA] Converting minutes to hours (Matthew Bohne 2008) [WebDNA] Converting minutes to hours (Suzanne Swift 2008)

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.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:

New public beta available (1997) Misunderstanding?? (1997) Best way to handle 404 errors with WebDNA and Web* V (2003) What is WebDNA (1997) NT vs Mac (1997) For those of you not on the WebCatalog Beta... (1997) Conditional searching & displaying (1997) Netscape Error Message Document Contains No Data (1998) Graphing Modules (2004) pc (1997) [append] vs. [appendfile] delta + question? (1997) Show Databases in admin (2000) Sendmail Enigma (2004) Problems getting parameters passed into email. (1997) Further tests with the infamous shipCost (1997) Signal Raised (1997) Online Docs? (1997) WebCat2: Items xx to xx shown, etc. (1997) Sort Order on a page search (1997) Sorting by date (1997)