Re: [WebDNA] Converting minutes to hours

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101183
interpreted = N
texte = We actually don't round time off...all time is entered in 15 minute increments. On Oct 15, 2008, at 3:48 PM, Matthew Bohne wrote: > 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/ >> >> > > --------------------------------------------------------- > 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)
We actually don't round time off...all time is entered in 15 minute increments. On Oct 15, 2008, at 3:48 PM, Matthew Bohne wrote: > 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/ >> >> > > --------------------------------------------------------- > 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/ 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:

Version f1 status (1997) problems with 2 tags (1997) OT: ASP Developer (1999) Looking for WebSTAR bomb at startup (2000) Just a thought (1998) mass mailing (1998) Users and groups for local directories (1999) Field names beginning with Reg.. (2002) Applescript Hack (1996) Snake Bites (1997) WC2.0 Memory Requirements (1997) Credit Card Verification.... (1998) Thanks for the cool new beta! (2000) form data submission gets truncated (1997) ANNC: Cool New WebCat Site!!! (Lotsa Flash) (2000) Forms Search Questions (1997) OT: Safari/Mac - frames and iframes acting weird (2007) Has ANYONE gotten the [object] context to work with Java(OSX) ??? HELP! (2002) Error Type 3 (1999) triggering an update of two frames (1998)