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:
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:
Writing [raw] to a file (2000)
How much is the Upgrade (2000)
Adding multiple items to Cart at one time, & append context problem (1998)
verify online (1997)
Multiple Items (2004)
[WebDNA] Base64 (2014)
Hideifs / Showifs (2000)
Showcart in [include] (1999)
form crasehes server (1997)
WebCat2 Append problem (B14Macacgi) (1997)
cart (1997)
ACGI processing for .html (1997)
Re:no [search] with NT (1997)
RE: Help name our technology! (1997)
Search for 20 finds 2000, 200 Why? (1997)
Bug? (1997)
WebDNA Solutions ... sorry! (1997)
Sku numbers (1997)
RE: Problem (1997)
Don't tick me off :) [elaspedtime] (1997)