[WebDNA] Converting minutes to hours

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101177
interpreted = N
texte = 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 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)
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 Suzanne Swift

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:

wrong input values? (1997) Generating unique SKU from [cart] - Still Stumped... (1997) trouble updating records in database (1998) Paths (2000) find with exceptions (1997) WebCat2b12 CGI Mac - [shownext] problem (1997) Client-side Image Maps and WebCat? (1998) HELP! Search finding too much! (1998) Using WC for Bulk Emailings (1997) test (2001) Error: Can't open order file. Ignoring [OrderFile] context (2000) Overridding E-Mailer (1998) Shownext and search context (2000) b18 problem on NT 4.0 (1997) Server Freeze (1998) unsubscribe (1997) formula.db problems (1999) [ModDate] & [ModTime] ? (1997) Omnibase file manipulation utility (1999) Show only certain items (2002)