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:
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)