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.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. Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Converting minutes to hours (Brian Fries 2008)
  2. Re: [WebDNA] Converting minutes to hours (Jeffrey Jones 2008)
  3. Re: [WebDNA] Converting minutes to hours (Terry Wilson 2008)
  4. Re: [WebDNA] Converting minutes to hours (Suzanne Swift 2008)
  5. Re: [WebDNA] Converting minutes to hours (Suzanne Swift 2008)
  6. Re: [WebDNA] Converting minutes to hours (Suzanne Swift 2008)
  7. Re: [WebDNA] Converting minutes to hours (Terry Wilson 2008)
  8. Re: [WebDNA] Converting minutes to hours (Matthew Bohne 2008)
  9. Re: [WebDNA] Converting minutes to hours (Gary Krockover 2008)
  10. Re: [WebDNA] Converting minutes to hours (Matthew Bohne 2008)
  11. [WebDNA] Converting minutes to hours (Suzanne Swift 2008)
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. 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:

LetterRip and WebCat & more (1998) How to put the Trademark Symbol (%99) in Sendmail? (2003) WebCatalog can't find database (1997) getchars broken? (1997) no word on MacAuthorize... (1997) Missing contexts on NT (1997) Email Scavengers (2003) [Format thousands .2f] and negative values (2001) Date sorting (2000) LookUp (2001) No Data Results (1997) transferring values (1998) [OT] Connect to MySQL (2004) Frames and WebCat (1997) no global [username] or [password] displayed ... (1997) WebCat2 beta FTP site (1997) TCPConnect / Current Temperature (2004) Weird problems with [SHOWIF]s (1997) Help with sorting search results sorting (1998) Foreign Language [DATE] formats (2004)