Re: [WebDNA] Converting minutes to hours

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101178
interpreted = N
texte = How do the minutes round? For instance, is 4:07 rounded to 4:00 or 4:15? What about 4:58? Suzanne Swift wrote: > 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/ > > 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)
How do the minutes round? For instance, is 4:07 rounded to 4:00 or 4:15? What about 4:58? Suzanne Swift wrote: > 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/ > > Matthew Bohne

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:

WebCat2: Items xx to xx shown, etc. (1997) Multiple catalog databases and showcart (1997) Encrypting userid for email (2000) No subject given (2000) ImageMagick (2005) More on the email templates (1997) [isfile] ? (1997) [OT] Theiving B*****ds (2004) Web Catalog 2 demo (1997) displaying New products (Yikes! it's Fixed!) (1997) The Guru Speaks (1998) email error 159 (1998) Emailer Problem (2000) [OT] Friday Time Waster (2003) Problem with imagemap variables (2006) RE: [WebDNA] macOS 10.13.3 and WebDNA Mac Server 8.5.1 - hick-up (2019) all records returned. (1997) (OT) Dual 2GHz G5 (2003) credit card authorization question (1997) WebCommerce: Folder organization ? (1997)