Re: [WebDNA] Converting minutes to hours

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101179
interpreted = N
texte = --=====================_36092046==.ALT Content-Type: text/plain; charset="us-ascii" Does your database store a bunch of entries such as: HOUR MINUTES 1 30 0 45 2 15 ? GJK At 02:24 PM 10/15/2008, you 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 --=====================_36092046==.ALT Content-Type: text/html; charset="us-ascii" Does your database store a bunch of entries such as:

HOUR    MINUTES
1       30
0       45
2       15

?

GJK

At 02:24 PM 10/15/2008, you 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 <br><br>
Total Cost: $[math][HoursTotal]*[lookup 
db=my.db&value=[Employee]&lookInField= Employee&returnField= 
Employee_Rate&notFound=][/math]<br></font>

Thanks!
Suzanne
--=====================_36092046==.ALT-- 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)
--=====================_36092046==.ALT Content-Type: text/plain; charset="us-ascii" Does your database store a bunch of entries such as: HOUR MINUTES 1 30 0 45 2 15 ? GJK At 02:24 PM 10/15/2008, you 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 --=====================_36092046==.ALT Content-Type: text/html; charset="us-ascii" Does your database store a bunch of entries such as:

HOUR    MINUTES
1       30
0       45
2       15

?

GJK

At 02:24 PM 10/15/2008, you 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 <br><br>
Total Cost: $[math][HoursTotal]*[lookup 
db=my.db&value=[Employee]&lookInField= Employee&returnField= 
Employee_Rate&notFound=][/math]<br></font>

Thanks!
Suzanne
--=====================_36092046==.ALT-- Gary Krockover

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:

search for all (1998) re:Clickable maps and WebCatalog? (1996) Multiple prices (1997) Download capabilities (1997) New WebDNA Solutions ... (1997) Webcat/Webmerchant part II (1998) Version f1 status (1997) Databases going to sleep (1998) Thanks for tips, more quest (1997) passing cart value (2003) Too many webcat comments. [WAS- Large founditems loops] (2000) How true is this? (1999) [TaxableTotal] - not working with AOL and IE (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) unclear on a simple [cart] ? (1998) WebCat2 - Getting to the browser's username/password data (1997) Further on formula.db failure to calculate shipCost (1997) Protecting Images (2003) Exclamation point (1997) Question on lineitems (2002)