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:

[Webcat 2]Next (1997) Search/sort in URL Was: GuestBook example (1997) Opinion: [input] should be called [output] ... (1997) [searchString] (1997) BBEdit and WebCatalog 2.0? (1997) Search Folder? (1998) WebCat2 - [format thousands] (1997) Cyberstudio and WebDNA (1997) SMSI: WebDNA Versions? (2002) all records returned. (1997) Here we go again... (2006) Re:no template caching (1997) WebCat2b12 - nesting [tags] (1997) Upgrade to Tiger? (2006) Newbie questions (1999) Bug Report, maybe (1997) NetSplat and WebCat2 (1997) [WebDNA] [BULK] WebDNA 7 and Mac OS X (10.6.7) Server Version [installation] (2011) using showpage and showcart commands (1996) Country & Ship-to address & other fields ? (1997)