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==.ALTContent-Type: text/plain; charset="us-ascii"Does your database store a bunch of entries such as:HOUR MINUTES1 300 452 15?GJKAt 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==.ALTContent-Type: text/html; charset="us-ascii"
Does your database store a bunch of entries suchas:
HOUR MINUTES
1 30
0 45
2 15
?
GJK
At 02:24 PM 10/15/2008, you wrote:
I'm trying to convert minutes tohours 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 tofigure
out a way to convert the minutes to part of an hour and thenmultiple
by the pay rate. Does anyone know how to do this using WebDNAversion
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¬Found=][/math]<br></font>
Thanks!
Suzanne
--=====================_36092046==.ALT--
Associated Messages, from the most recent to the oldest:
--=====================_36092046==.ALTContent-Type: text/plain; charset="us-ascii"Does your database store a bunch of entries such as:HOUR MINUTES1 300 452 15?GJKAt 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==.ALTContent-Type: text/html; charset="us-ascii"
Does your database store a bunch of entries suchas:
HOUR MINUTES
1 30
0 45
2 15
?
GJK
At 02:24 PM 10/15/2008, you wrote:
I'm trying to convert minutes tohours 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 tofigure
out a way to convert the minutes to part of an hour and thenmultiple
by the pay rate. Does anyone know how to do this using WebDNAversion
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¬Found=][/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)